Introducing two methods of manually configuring phpmyadmin and mysql passwords

The following tutorial column of phpmyadmin will introduce to you two solutions for manually configuring phpmyadmin and mysql passwords. I hope it will be helpful to friends in need!

##Option 1:

1. Enter: mysql> and enter

2. Select the mysql database: mysql> use mysql;
3. Change user table data: mysql> update user set password=password('new password') where user='root';
4. Activate permissions: mysql> FLUSH PRIVILEGES;
5. Exit mysql: mysql> ; quit;
Change the phpmyadmin password: Find the configuration file config.inc.php in php and set $cfg['Servers'][$i]['password'] = 'Set to the same password as the above database';

Option 2:

1.phpmyadmin
2. Select mysql database
3. Scholar user table
4. Modify User as root password
Change phpmyadmin password: Find the configuration in php The file config.inc.php sets $cfg['Servers'][$i]['password'] = 'Set to the same password as the above database';

The above is the detailed content of Introducing two methods of manually configuring phpmyadmin and mysql passwords. For more information, please follow other related articles on the PHP Chinese website!