Pages

Bài đăng phổ biến

Showing posts with label How to: MySQL Reset Password root. Show all posts
Showing posts with label How to: MySQL Reset Password root. 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