MySQL: Difference between revisions

From The Incoherency.Net Wiki
Jump to navigation Jump to search
Denis (talk | contribs)
New page: Image:Mysql.png ''Insert useful MySQL information here''
 
Denis (talk | contribs)
No edit summary
Line 1: Line 1:
[[Image:Mysql.png]]
[[Image:Mysql.png]]


''Insert useful MySQL information here''
= Reset MySQL root Password =
 
# Stop the MySQL server process.
# Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for password
# Connect to mysql server as the root user
# Setup new root password
# Exit and restart MySQL server

Revision as of 18:06, 12 August 2009

Reset MySQL root Password

  1. Stop the MySQL server process.
  2. Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for password
  3. Connect to mysql server as the root user
  4. Setup new root password
  5. Exit and restart MySQL server