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
Error:Access denied for user 'root'@'localhost'
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
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'
Usually you just have to change it in 'mysql.ini' file.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
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
-> 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.
-> 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.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
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
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