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

I see hundreds of mysql-bin.00xxxxxxx files in /var/lib/mysql directory. What are these files?

Starting MySQLCouldn't find MySQL manager or server

How can I check if query cache is working on my MySQL server?

HowTo :: commands, statements, and clauses

Got a packet bigger than 'max_allowed_packet' bytes

MySQL :: HowTo fix Access-Denied Errors

Warning: MySQL server has gone away

Error :: Can't connect to [local] MySQL server

Who is exhausting MySQL resources on my server?

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES