| Author: Mohsin 04 Jul 2009 | Member Level: Silver | Rating:  Points: 2 |
Use this link:
http://www.cyberciti.biz/faq/mysql-change-root-password/
|
| Author: amitkumar 04 Jul 2009 | Member Level: Gold | Rating: Points: 2 |
I checked the same, Its not working
|
| Author: Deepika Haridas 04 Jul 2009 | Member Level: Diamond | Rating: Points: 2 |
Hi,
1) Login to mysql server, type following command at shell prompt:
$ mysql -u root -p
2) Use mysql database (type command at mysql> prompt):
mysql> use mysql;
3) Change password for user deepika:
mysql> update user set password=PASSWORD("NEWPASSWORD") where User='deepika';
4) Reload privileges:
mysql> flush privileges;
mysql> quit
Hope this helps..
Thanks & Regards,
Deepika
Editor
If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..
|
| Author: Deepika Haridas 04 Jul 2009 | Member Level: Diamond | Rating: Points: 2 |
Hi,
Also another way to do is
GRANT USAGE ON *.* TO user@host IDENTIFIED BY 'password';
Thanks & Regards,
Deepika
Editor
If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..
|
| Author: amitkumar 04 Jul 2009 | Member Level: Gold | Rating: Points: 2 |
still its not happening..
|
| Author: Deepika Haridas 04 Jul 2009 | Member Level: Diamond | Rating: Points: 2 |
Hi,
Are you getting any error while performing the steps?
If so, then paste the error here...
Thanks & Regards,
Deepika
Editor
If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..
|
| Author: Devendra 06 Jul 2009 | Member Level: Gold | Rating: Points: 2 |
Try to deepika suggestion i think she is right
|