skip to main | skip to sidebar

Vishnu Ugale

Thursday, November 18, 2010

Update the root password for mysql database

To update the password of mysql database for root user

1) Login in into mysql prompt.

mysql>UPDATE mysql.user SET Password=PASSWORD("*******") WHERE User="root";
mysql>FLUSH PRIVILEGES;

done.
Posted by Vishnu Ugale at 10:36 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2022 (1)
    • ►  November (1)
  • ►  2011 (6)
    • ►  June (1)
    • ►  April (2)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ▼  2010 (17)
    • ►  December (2)
    • ▼  November (5)
      • install clamAV on httpd server
      • Mysql dump and restore database
      • mysql access denied for user 'root@localhost' usin...
      • Update the root password for mysql database
      • check/repair file system - Linux
    • ►  May (2)
    • ►  March (1)
    • ►  February (1)
    • ►  January (6)
  • ►  2009 (7)
    • ►  December (3)
    • ►  November (1)
    • ►  September (2)
    • ►  April (1)
  • ►  2008 (4)
    • ►  September (1)
    • ►  July (1)
    • ►  June (2)

About Me

Vishnu Ugale
Pune, Maharastra, India
View my complete profile