Setting the root password

From MyWiki
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
 
 
MariaDB [(none)]> show databases;
+-----------------------+
| Database              |
+-----------------------+
| information_schema    |
| artportfolio          |
| bm_staff_data         |
| community             |
| gold                  |
| grad                  |
| learn_20120619        |
| learn_20130705        |
| learn_2014072101      |
| learn_gold_ac_uk      |
| luns_moodle2_test     |
| mahmoodle             |
| moodle2               |
| moodle2_luns_20120725 |
| mysql                 |
| test                  |
+-----------------------+
16 rows in set (0.00 sec)