Network - Server

Reset root password of mysql - Ubuntu

 Step 1: Stop MySQL Service.

sudo service mysql stop 

Step 2: Kill all running mysqld.

sudo killall -9 mysqld 

Step 3: Starting mysqld in Safe mode.

sudo mysqld_safe --skip-grant-tables --skip-networking & 

Step 4: Start mysql client

mysql -u root 

Step 5: After successful login, please execute this command to change any password.

FLUSH PRIVILEGES; 

Step 6: You can update mysql root password .

UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; 

for mysql > 5.7 use this instead of above:

UPDATE mysql.user SET authentication_string=PASSWORD('newpwd') WHERE User='root'; 

Step 7: Please execute this command.

FLUSH PRIVILEGES; 

Step 8: Exit mysql console

exit 

Step 9: Kill mysqld_safe and start mysql

sudo killall mysqld_safe && sudo service mysql start

0 Bình luận

Trở về
  • Setup window xp từ usb!
  • Setup window xp từ usb!

    Tôi xin chia sẻ với các bạn cách sử dụng USB để làm bộ cài đặt windows xp, giống như một đĩa...

  • Mysql command
  • Mysql command

     # [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. mysql> create database [databasename]; List...