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!