VPS
Main PagecPanel and DirectAdmin LicensingServer Management PlansVirtual Private ServersDedicated Servers
Control Panel Licensing
ServerTune ResellersResellersSpecial PromotionsServerTune SpecialsHomeAbout ServerTuneContact usTechnical SupportKB
ServerTune Main Page
Space
Space
Our most popular products:

SPECIAL PROMOTION: cPanel License $36 /month. more info

 Issues, Tips, and Solutions

Protect your server with Mod Security rules written specifically for your system. more info ...
Space
Search:    Advanced search
Browse by category:
:: KB Home / MySQL / HowTo :: change MySQL root password
HowTo :: change MySQL root password
Printer Friendly
Printer friendly
email to a friend
Email to friend
Add comment Add comment
Views: 354
Votes: 0
Comments: 0
Posted: 06 Dec, 2007
by: Support T.
* * * * *
Updated: 06 Dec, 2007
by: Support T.

Run the following commands at the prompt

  • /etc/init.d/mysql stop
  • mysqld_safe --skip-grant-tables &

Connect to MySQL server

  • mysql -u root
    • mysql> use mysql;
    • mysql> update user set password=PASSWORD("YOUR_NEW_PASSWORD") where User='root';
    • mysql> flush privileges;
    • mysql> quit
  • /etc/init.d/mysql stop
  • /etc/init.d/mysql start
  • mysql -u root -p
Other articles in this Category
document I see hundreds of mysql-bin.00xxxxxxx files in /var/lib/mysql directory. What are these files?
document Starting MySQLCouldn't find MySQL manager or server
document How can I check if query cache is working on my MySQL server?
document HowTo :: commands, statements, and clauses
document Got a packet bigger than 'max_allowed_packet' bytes


RSS
Last update: August, 2008 ••• Copyright (c) 2004-2008 ServerTune Inc.