Pages

Bài đăng phổ biến

Showing posts with label reset password mysql. Show all posts
Showing posts with label reset password mysql. Show all posts

Sunday, November 13, 2011

How to: reset pass root mysql

1. Stop mysql:
# service mysqld stop
or
#killall mysql

2..mysqld_safe --skip-grant-tables
3.Access mysql without password
4.Create new mysql root password :
UPDATE mysql.user SET Password=PASSWORD('YOUR-NEW-MYSQL-PASSWORD') WHERE User='root';
FLUSH PRIVILEGES;
4.killall mysqld
5.service mysqld start


Nguyen Si Nhan