| HowTo :: change MySQL root password |
 |
|
 |
Email to friend
|
 |
Add comment
|
|
|
|
Views: 1438
Votes: 0
Comments: 0
|
Posted: 06 Dec, 2007
by: Customer Service :: S.
* * * * *
Updated: 06 Dec, 2007
by: Customer Service :: S. |
|
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
|
Last update: March 21st, 2010 ••• Copyright © 2004-2010 ServerTune Inc.
