Difference between revisions of "Setting the root password"
From MyWiki
| Line 3: | Line 3: | ||
-> WHERE User='root'; | -> WHERE User='root'; | ||
mysql> FLUSH PRIVILEGES; | mysql> FLUSH PRIVILEGES; | ||
| + | |||
| + | |||
| + | mysqld_safe --skip-grant-tables & | ||
</source> | </source> | ||
Revision as of 11:32, 23 July 2015
mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
-> WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysqld_safe --skip-grant-tables &