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

phpMyAdmin is a mainstream MySQL database management software.

If you cannot create a MySQL database in the CWP control panel backend , you will need to create the MySQL database and add user accounts through phpMyAdmin.

When installing the WordPress website building program, we also need to create a new MySQL database and add new users.

How does phpMyAdmin create a MySQL database?

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

Step 2: Create a new MySQL database. In the right-hand window of phpMyAdmin, enter 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, click "Add New User" ▼

Step 5: Enter the username, access scope, and password for the new MySQL database ▼

• 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 the MySQL user, 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 specific access permissions to modify the user database in the permissions settings.

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