Access denied for user ''@'localhost' to database 'user'

Question

I am facing a problem in signing in mysql. I had mistaknely renamed user name from "root" to "xyz" and password as password. Then onwards I couldnot run MySql from commandline using the root password which I set. Even can't proceed with the show database and table creation queries. User shows 'root'@'localhost' whereas current_user() is ''@'localhost' I reinstalled MySql still the problem is there.

Please help me so that I can proceed with the mysql.

Thanks in advance, Rajhrita

Jim Garrison · Accepted Answer · 2012-05-28 05:06:17Z

1

Use the procedure at http://www.cyberciti.biz/tips/recover-mysql-root-password.html to bypass security and recreate the password.

answered May 28, 2012 at 5:06

Jim Garrison

87k20 gold badges161 silver badges196 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Access denied for user ''@'localhost' to database 'user'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related