Difference between revisions of "Setting the root password"
From MyWiki
| Line 6: | Line 6: | ||
mysqld_safe --skip-grant-tables & | mysqld_safe --skip-grant-tables & | ||
| + | |||
| + | |||
| + | mysql> use mysql; | ||
| + | mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; | ||
| + | mysql> flush privileges; | ||
| + | mysql> quit | ||
| + | |||
| + | |||
| + | === | ||
| + | ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist | ||
| + | MariaDB [mysql]> flush privileges; | ||
| + | ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist | ||
| + | |||
</source> | </source> | ||
Revision as of 11:34, 23 July 2015
mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
-> WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysqld_safe --skip-grant-tables &
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit
===
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
MariaDB [mysql]> flush privileges;
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist