Phpmyadmin creates database users (local, any host)

Phpmyadmin allows you to create users for databases through phpmyadmin and Set permissions. Both User Creation and permission configuration are simple. The root user is used to create any user and can assign all permissions. The super administrator of mysql, of course, belongs to the local user. Local Users provide access to the same host as the database.

Phpmyadmin allows you to create users for databases through phpmyadmin and Set permissions. Both User Creation and permission configuration are simple. The root user is used to create any user and can assign all permissions. The super administrator of mysql, of course, belongs to the local user. Local Users provide access to the same host as the database.

Phpmyadmin User Creation

You can use phpmyadmin to create a database user and Set permissions. Both User Creation and permission configuration are simple.

Root User

It is used to create any user and can assign all permissions. The super administrator of mysql, of course, belongs to a local user.

Local user

A local user provides access to the database for the same host as the database. A user can have a password or no password. Local users cannot connect to remote SQL using the client tool (phpmyadmin, sqlyog, etc,

Regardless of the user's permissions, even if all users, regardless of the user's password, cannot connect to remote SQL.

Arbitrary host user

Any Host user provides access to the database for different hosts than the database. The user can have a password or no password. Any Host user cannot log on to the Database Host.

(If the password of any host user with ownership is blank, you can log on to the l local database, but you do not have the permission to create a database. You can only view the test and information_schema databases that come with mysql)

Create a database user

Select "Add User" next to "Number 1" to create various database users. Then, select "reload permission" to refresh the "user overview" column at "Number 3.

P.S number 3 user description

% Represents any host user, and localhost represents a local user

Users of user1, user2, and user3 can directly log on to the local database (although any host user, but the password is blank), and permissions are lost. Of course, if you log on from another host client, the permission is maintained.

User5 users can directly log on to the local database to maintain their permissions. You cannot log on from another host client.

User6 users cannot log on to the local database directly, but can log on from other host clients to maintain their permissions.

Users of user7 and user8 can directly log on to the local database to maintain their permissions. You cannot log on from another host client.