Leon Anavi
IT Tips && Tricks


Created: 08.09.2009 23:48 Last Modified: 08.09.2009 23:52 Views: 7486
Keywords: MySQL, password, phpMyAdmin, root

MYSQL: Change root Password Using SQL


Log into MySQL, select database mysql and execute an update statement with the new password. It is important to set the user name (root) at the where clause of the statement. The same method can be used to change password of any other user. The changes will take effect after restarting MySQL.


mysql> use mysql;
Database changed
mysql> update user set password=PASSWORD('mypassword') where User='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0

Configure phpMyAdmin

After the change of the root password phpMyAdmin will no longer have access to the database. To fix this issue locate the installation directory of the phpMyAdmin and open file config.inc.php. Navigate to the line that starts with $cfg['Servers'][$i]['password'] and modify it:
$cfg['Servers'][$i]['password'] = 'mypassword';

Reference Manual


  Home | About | Contact | Disclaimer | Sitemap 2009-2022 Leon Anavi. All rights reserved.