How to manage and create MySQL database on VPS

The database management software installed by VPS by default is phpMyAdmin, which is a software specially used for online management of MySQL databases. The software is written in PHP. For security reasons when creating a new database, only give yourself read/write permissions for the newly created database.

How to create a Mysql database using phpMyadmin

1. First we need to log in to phpMyAdmin. Click "Control Panel" → "Administrative Tools" → "Internet Information Service Manager", the "Internet Information Service Manager" window will pop up, find the homepage index.php of the phpMyAdmin website under [Default Website], right-click to browse, and open phpMyAdmin's Manage landing pages.

2. Create a database, as shown below. In the right window of php MyAdmin, fill in the database name and click Create.

3. For example, we create a database named: cncmstest
If the creation is successful, there will be The following prompts:

4. Click the home button in the upper left corner to return to the php MyAdmin main interface:

5. Click "Permissions" on the right side of the main interface to create a database account.

##6. In the permissions page, we click "Add New User"

#7. In this page, we fill in the database user name to be created, the user's access scope, and password.

8. As shown in the picture above, we filled in the user name: cncmsuser. This database user only allows local access. Select local for the host; we use the automatically generated password. Click "Generate" below to generate a random password, and then click "Copy" to automatically fill in the password box. Do not select any of the boxes below, just scroll to the bottom of the page and click Execute to create a new user.
The database user is successfully created and the following page will be returned:

9. The most important step is to set up the user Database access permissionsPermissions can be set directly on the page returned after the database user is successfully added. Here we choose to specify permissions by database:

10. As shown above, select the cncmstest we just created in the database list , which will automatically enter the permission setting page of the database.

11. In the permission settings in the picture above, we check both "data" and "structure" Select all column permissions and leave none of the management permissions selected. Just click Execute.

Remarks: If you find it troublesome or don’t understand, you can use it yourself [Website Management Assistant] creates a new MYSQL database in vps.

The above is the detailed content of How to manage and create MySQL database on VPS. For more information, please follow other related articles on the PHP Chinese website!