понедельник, 1 октября 2018 г.

Mysql 5.7 root empty password and Ubuntu

sudo mysql -u root

mysql> use mysql;

mysql> update user set plugin='mysql_native_password' where User='root';

mysql> set password = password('_new_root_password_');

[mysql] flush privileges;

check:

mysql -u root -p
enter new root password