Setting the root password

From MyWiki
Revision as of 11:34, 23 July 2015 by George2 (Talk | contribs)

Jump to: navigation, search
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