nguyenminh

MySQL root password change

Please follow the below steps.

sudo service mysql stop
sudo mysqld_safe –skip-grant-tables
sudo service mysql start
sudo mysql -u root
use mysql;
show tables;
describe user;
update user set authentication_string=password(‘1111′) where user=’root’;
FLUSH PRIVILEGES;

Categorised in: Tổng hợp

0 Comments for "MySQL root password change"

2 thoughts on “MySQL root password change”

  1. admin says:

    mysql_secure_installation if pass root is null

  2. Nice article thank you for sharing

Leave a Reply

Your email address will not be published. Required fields are marked *