Change root password in MySQL 8

SQL - 本文屬於一個選集。

§ : 本文

Change the password of root in mysql version 8

mysqld_safe
#

You maybe need sudo in your case.

1# turn off mysqld
2/etc/init.d/mysql stop
3
4# use safe mode
5mysqld_safe --skip-grant-tables &

If it show the error message:

1mysqld_safe Logging to '/var/log/mysql/error.log'.
2mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.

Try this before run the safe mode of mysqld:

1mkdir -p /var/run/mysqld
2chown mysql:mysql /var/run/mysqld

In this mode, you can login root without password.

1mysql -u root

In the old version(MySQL version lower than 8), you may use SET PASSWORD=PASSWORD('password'); to change password.

But in version 8, you need to change the method:

1USE mysql;
2ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
3FLUSH PRIVILEGES;
4exit;

Start the service

1killall mysqld
2/etc/init.d/mysqld start

Try it

1mysql -u root -p
2# type password

作者

Alpaca

No one can stop my feet.

SQL - 本文屬於一個選集。

§ : 本文