mySQL databases and Radiant...uggg

rubyonrails-talk
#1

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?

#2

Bryce Roney wrote:

> 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 Ororie <

Presumably... it's the admin account - i got no password prompt
regardless though...

#3

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?

#4

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.

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?

#5

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

#6

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.

grant all on radiant_cms_development.* to root@'%' identified by

'root';
Query OK, 0 rows affected (0.00 sec)

create table dummy(i int);

Query OK, 0 rows affected (0.00 sec)

drop table dummy;

Query OK, 0 rows affected (0.00 sec)

Would LOVE to get to the bottom of this.

#7

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

#8

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