Submitted by Rajhrita on Fri, 05/25/2012 - 04:56
Hi Forum,
I've mistakenly changed MYSQL root user name from "root" to "xyz" using COMMAND : >update mysql.user set user='xyz' where user='root'; >flush privileges;
But after exiting from MySql when I tried to reopen command prompt of MySql I could not enter using the previous password and whenevr I was trying to use mysql database it was showing : Access denied for user ''@'localhost' to database 'mysql'
I have also tried with changing root password and finally reinstalled the mysql but same thing is happening till now.
Till now using Command : >select user(),current_user(); I am getting user - root@localhost and current_user - ''@localhost
Please help me in that so that I can connect mysql and proceed with my work.
Thanks in advance
Rajhrita
Status:
Closed (fixed)
Comments
Submitted by andreychek on Fri, 05/25/2012 - 08:27 Comment #1
Howdy -- it looks like you posted your request in the forums here:
https://www.virtualmin.com/node/22312
That's the right place to post support requests for anyone using Virtualmin GPL. I did respond there with something that will hopefully help you out though!