Ask Your Question
0

Can't connect to MySQL after configuration

asked 2012-04-17 16:45:32 -0500

marco-consonni gravatar image

Hello,

I've just configured MySQL for supporting nova as described here http://docs.openstack.org/trunk/openstack-compute/install/content/setting-up-sql-database-mysql.html (http://docs.openstack.org/trunk/opens...)

Then, I tested the connection to MySQL as as the user created by the MySQL instruction

GRANT ALL ON nova.* TO 'nova'@'%' IDENTIFIED BY 'yourpassword';

I get the following error:

ERROR 1045 (28000): Access denied for user 'nova'@'localhost' (using password: YES)

I'm pretty sure that the credentials I typed are correct.

In order to surpass the problem, I dropped the just created user and create again with:

GRANT ALL ON nova.* TO 'nova'@'localhost' IDENTIFIED BY 'yourpassword';

It works but it is not what I wanted because I want that the user can connect from any other server.

The point is that I tested exactly the same stuff on a different (previous) version of MySQL and it works as expected.

Version OK: mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1 Version NOK: mysql Ver 14.14 Distrib 5.5.22, for debian-linux-gnu (i686) using readline 6.2

Can anybody help me?

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2012-04-26 15:31:03 -0500

jkyle gravatar image

Please see the 3rd bullet point for an explanation of the behavior you're seeing and a solution:

http://dev.mysql.com/doc/refman/4.1/en/adding-users.html (http://dev.mysql.com/doc/refman/4.1/e...)

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2012-04-17 16:45:32 -0500

Seen: 23 times

Last updated: Apr 26 '12