Wednesday, April 22, 2015

Forgot msyql-mariadb password ubuntu 14



Stop msyql process:

sudo service mysql stop

Run mysql as safe service:

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

Log on with root use and without any password:

mysql -u root

change database:

use mysql;

Change password for root user:

update user set password=PASSWORD("new-password") where User='root';

Commit changes:

flush privileges;


Leave mysql client:

quit;

No comments: