Home  >  Article  >  Database  >  phpmyadmin changes the default password (detailed picture and text explanation)

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

藏色散人
藏色散人forward
2020-11-25 15:03:314647browse

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!

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

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

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

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

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

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!

Statement:
This article is reproduced at:jianshu.com. If there is any infringement, please contact admin@php.cn delete