How does phpMyAdmin create a MySQL database? Add a user to set account permissions

phpMyAdmin is mainstreamMySQL databaseManagementsoftware.

If inCWP Control PanelBackground cannot be createdMySQLDatabase, you need to create a MySQL database and add a new user account through phpMyAdmin.

When we installWordPress websiteDuring the program, it is also necessary to newly create a MySQL database and add a new user.

How does phpMyAdmin create a MySQL database?

Step 1:First, we need to log into the phpMyAdmin database management software.

Step 2:Create a new MySQL database, in the right window of phpMyAdmin, fill in the database name, and click Create ▼

Step 3:After the MySQL database is created, click "Permissions" on the right side of the main interface to create a database user ▼

How to add user account in phpMyAdmin?

Step 4:On the permissions page, we click "Add New User" ▼

Step 5:Enter the user name, access scope and password of the MySQL database you want to add▼

• We fill in the MySQL database username aschenweiliang.com;
• MySQL database users only allow local access, so select "local" for the host name;
• We can use the automatically generated password, click "Generate" below to generate a random password, and then click "Copy" to automatically fill in the password box, or you can define your own password.
• By default, the system will user-friendly check "Grant all permissions to the database chenweiliang", which is what we want.

How to choose the hostname of the new user in phpMyAdmin?

There are 4 options here: any host (%), local (localhost), use host table (host), use text field (i.e. use text field).

1. "Any host" means match all hosts;
2. "local" means only the local host (default fills in localhost);
3. "Using the host table" means that the data in the host table in the MySQL database shall prevail, and there is no need to fill in the information (if filled, this option is invalid);
4. "Using a text field" means that you fill in the host address information yourself.

Step 6:Configure global permissions for MySQL users, select "Select All" ▼

• Then, pull to the bottom of the page and click "Execute" to successfully create a new user.

Step 7:After the user is created, you can also set the specific access rights to modify the user database in Permissions.

• If you don't need to modify permissions, you can leave it alone.