mySQL databases and Radiant...uggg


#1
  • Trying * (hard) to get Radiant CMS to work for me here. Based on these
    instructions:

http://wiki.radiantcms.org/Database_Configuration

I created my development database, but when I try to use the ‘grant all’
command to tell it the user name and pass this is what I get:

mysql> grant all on radiant_cms_development.* to root@’%’ identified by
‘root’;
ERROR 1044 (42000): Access denied for user ‘’@‘localhost’ to database
‘radiant_cms_development’

I am assuming that I created it properly based on this:

bio4054059:radiant_cms rmorourk$
/Applications/MAMP/Library/bin/mysqladmin -u root -proot create
radiant_cms_development
bio4054059:radiant_cms rmorourk$

This is what the development portion of my database.yml file looks like
after I edited it:

development:
adapter: mysql
database: radiant_cms_development
username: root
password: root
host: localhost
socket: /Applications/MAMP/tmp/mysql/mysql.sock

So I don’t know why I am getting an “accessed denied for user” ping
back, clearly those are the user name and password. Can I set the host
on this file to anything localhost:3006 ?

I know I have been posting a lot, but you guys have been a big help so
far - hoping the charity of knowledge continues. Thanks!

I feel like I got my rails setup off on the wrong foot - my mySQL stuff
is buried under the MAMP installation, I’m using locomotive which as far
as I can tell stops the terminal from setting up servers at the normal
local host. (it must all be done via locomotive). Any other advise on
how to “start-over” so to speak and use the proper way of doing things
with nice default-esc paths?


#2

mysql> grant all on radiant_cms_development.* to root@’%’ identified by
‘root’;
ERROR 1044 (42000): Access denied for user ‘’@‘localhost’ to database
‘radiant_cms_development’

Does the user you are using to issue this command have appropriate
permissions to GRANT permissions to others?

On Mon, Dec 22, 2008 at 4:30 PM, Ryan O. <


#3

Bryce R. wrote:

mysql> grant all on radiant_cms_development.* to root@’%’ identified by
‘root’;
ERROR 1044 (42000): Access denied for user ‘’@‘localhost’ to database
‘radiant_cms_development’

Does the user you are using to issue this command have appropriate
permissions to GRANT permissions to others?

On Mon, Dec 22, 2008 at 4:30 PM, Ryan O. <

Presumably… it’s the admin account - i got no password prompt
regardless though…


#4

On Mon, Dec 22, 2008 at 9:55 AM, Ryan O.
removed_email_address@domain.invalid wrote:

mysql> grant all on radiant_cms_development.* to root@’%’ identified by
‘root’;
ERROR 1044 (42000): Access denied for user ‘’@‘localhost’ to database
‘radiant_cms_development’

Presumably… it’s the admin account - i got no password prompt
regardless though…

It wouldn’t appear to be the “admin” account. What’s the exact
command you’re using to log in before you try this ‘grant’ statement?


Hassan S. ------------------------ removed_email_address@domain.invalid


#5

On Mon, Dec 22, 2008 at 12:13 PM, Ryan O.
removed_email_address@domain.invalid wrote:

bio4054059:radiant_cms rmorourk$ /Applications/MAMP/Library/bin/mysql

That should also be mysql -u root -proot if you want to have admin
privileges – which as a user you clearly don’t have.


Hassan S. ------------------------ removed_email_address@domain.invalid


#6

It wouldn’t appear to be the “admin” account. What’s the exact
command you’re using to log in before you try this ‘grant’ statement?

bio4054059:radiant_cms rmorourk$
/Applications/MAMP/Library/bin/mysqladmin -u root -proot create
radiant_cms_development
bio4054059:radiant_cms rmorourk$ /Applications/MAMP/Library/bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 23
Server version: 5.0.41 Source distribution

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> grant all on radiant_cms_development.* to root@’%’ identified by
‘root’;
ERROR 1044 (42000): Access denied for user ‘’@‘localhost’ to database
‘radiant_cms_development’

That’s what I am doing, Creating it via mysqladmin cmd then going into
the mysql prompt, then trying to grant permissions to it. Any thoughts?


#7

shouldn’t the line:
host: localhost:3006
in your database,yml file be the anouncement for where your mysql is
running?

On Dec 23, 8:32 am, Ryan O. removed_email_address@domain.invalid


#8

That should also be mysql -u root -proot if you want to have admin
privileges – which as a user you clearly don’t have.

Thank you. Worked fine. But, still can’t seem to get Radiant up and
running locally.

My database.yml looks like:

development:
adapter: mysql
database: radiant_cms_development
username: root
password: root
host: localhost:3006
socket: /Applications/MAMP/tmp/mysql/mysql.sock

I changed host from ‘localhost’ to ‘localhost:3006’ because (via
locomotive) that is where I set the radiant_cms project to be.

Only when going to http://localhost:3006/ I get this error:
Mysql::Error: Table ‘radiant_cms_development.config’ doesn’t exist: SHOW
FIELDS FROM config

Which confuses me, because as you can see from the following output - I
can talk to the database (and therefore it must have the config table?)

bio4054059:radiant_cms rmorourk$ /Applications/MAMP/Library/bin/mysql -u
root -proot radiant_cms_development
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 57
Server version: 5.0.41 Source distribution

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> grant all on radiant_cms_development.* to root@’%’ identified by
‘root’;
Query OK, 0 rows affected (0.00 sec)

mysql> create table dummy(i int);
Query OK, 0 rows affected (0.00 sec)

mysql> drop table dummy;
Query OK, 0 rows affected (0.00 sec)

Would LOVE to get to the bottom of this.


#9

Ryan O. wrote:

ERROR 1044 (42000): Access denied for user ‘’@‘localhost’ to database
after I edited it:
back, clearly those are the user name and password. Can I set the host
with nice default-esc paths?

Is your ‘root’ user configured to have a password ‘root’?

Cheers,
Mohit.
12/26/2008 | 4:34 PM.


#10

On 23 Dec 2008, at 00:32, Ryan O. wrote:

I changed host from ‘localhost’ to ‘localhost:3006’ because (via
locomotive) that is where I set the radiant_cms project to be.

Only when going to http://localhost:3006/ I get this error:
Mysql::Error: Table ‘radiant_cms_development.config’ doesn’t exist:
SHOW
FIELDS FROM config

the host is where the mysql server is, ie not port 3006. That’s
irrelevant though since you’re connecting via a unix domain socket

Which confuses me, because as you can see from the following output

  • I
    can talk to the database (and therefore it must have the config
    table?)

It can talk to the database. It’s probably just telling you that the
database is empty. I don’t know radiant but I would expect you need to
run rake db:schema:load or similar to create the tables radiant uses.

Fred