phpmyadmin changes the default password (detailed picture and text explanation)

Below, phpmyadmin uses the tutorial column to introduce to you how to change the default password of phpmyadmin (detailed pictures and texts). I hope it will be helpful to friends in need!

set password=password('hello');//root密码修改为hello

User information in mysql is stored in the user table of the system database mysql:

Create user
Grammar form:

create  user  ‘用户名’@’允许其登录的地址’  identified  by  ‘密码’;

Description:
1. When creating a user, you must also specify the address at which the user can log in.
Where "%" represents "any address".
2. After the user is created, a record is automatically added to the user table of mysql, but the user does not have permission yet.

Delete user
drop user 'username'@'address that allows login';

Modify user password
Modify your own password: set password = password( 'New password');
Modify other people's passwords (must have permission to modify):
set password for 'Username'@'address that allows them to log in' = password('new password');

The above is the detailed content of phpmyadmin changes the default password (detailed picture and text explanation). For more information, please follow other related articles on the PHP Chinese website!