PhpMyAdmin creates a mysql database on the server

This article describes how to use phpmyadmin to create a database on the server. This is a convenient instance tool. If you need it, refer to the workshop.

Open phpMyAdmin and log on as the root user,

In the middle of the homepage, there is a line "Create a new database", enter the database name, and click "CREATE" to create a database.

Click "Permissions" in the lower part of the home page to go to permission management and click "Add new user ".

Then, "User Name", "Use text domain", enter the user name, "host", "Any Host", and enter the password; "password", "Use text domain", and enter the password; enter the password again. "Database for user", select "Create database with same name and grant all privileges", and click "execute" at the bottom ", then a user is created and authorized. But not yet. Click the "permission" tab in the upper part of the page that prompted the user to be successfully added, return to permission management, and click "Add new user" again ". Repeat the previous operation. Change "host" to "local", and then "localhost" will be automatically displayed ". The other items are exactly the same once. Click "execute" again and prompt "success". Then, the task of creating a database and a user is completed.

The first step "create database" in this process can be omitted. The database is automatically created when you add a user.