Page 1 of 1
Error:Access denied for user 'root'@'localhost'
Posted: Tue Oct 10, 2006 12:38 pm
by eshban
I am trying to apply password on MYSQL, dont know what happens.
now when i open
http://localhost/phpmyadmin
i got the following error.
1045 - Access denied for user 'root'@'localhost' (using password: NO)
plz guide that how to remove the pasword
and how to apply new password to mysql
thanks
Posted: Tue Oct 10, 2006 7:00 pm
by RobertGonzalez
You are going to need to get into mysql as root. I would imagine that you would have to use the command line if PMA is not working for you. Of course, the obvious question to start with is which PHP version are you using, which MySQL version are you using and what is your current MySQL Client API version?
Re: Error:Access denied for user 'root'@'localhost'
Posted: Tue Oct 10, 2006 7:45 pm
by chakhar86
eshban wrote:I am trying to apply password on MYSQL, dont know what happens.
now when i open
http://localhost/phpmyadmin
i got the following error.
1045 - Access denied for user 'root'@'localhost' (using password: NO)
plz guide that how to remove the pasword
and how to apply new password to mysql
thanks
Usually you just have to change it in 'mysql.ini' file.
Posted: Tue Oct 10, 2006 11:48 pm
by RobertGonzalez
There are no passwords in my.conf. The root user is actually stored in the user table of the mysql database. This sounds like a client api issue.
Posted: Thu Oct 12, 2006 7:36 am
by amir
-> come to this page
http://localhost/phpmyadmin/
-> u will c here a link Privileges
-> click it now , here u can add a new user and also change the password of old user.
Posted: Thu Oct 12, 2006 10:07 am
by RobertGonzalez
If he can't log in as root then he won't be able to add users unless the login that he uses has global permissions.
Posted: Thu Oct 12, 2006 4:48 pm
by cinac
If you set a user password, you need to reload MySQL so it will reread the info. Just do a "flush privileges;" command at the command line.
If you can't get into the command line tool since you don't know the password, stopping and restarting the MySQL process will have the same effect as the flush privileges; then the new password should be in effect.
If you've totally forgotten the password or something, you can start MySQL with the --skip-grant-tables switch, set the password, then stop/restart MySQL normally.
See
http://dev.mysql.com/doc/refman/5.0/en/ ... sions.html for more info