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:
Post a Comment