PhpMyadmin: creating databases and setting user permissions _ PHP Tutorial

PhpMyadmin creates databases and sets user permissions. Phpmyadmin is a good WEB-based mysql database management software. if you want to create a database and set user permissions, you must perform operations with high user permissions, such as ROOT permissions, below I phpmyadmin is a very good WEB-based mysql database management software. if you want to create a database and set user permissions, we must operate on the user's high permissions, such as ROOT permissions, next I will introduce it to you.

Configure phpmyadmin first, or you cannot log on.

Go to the libraries directory under phpmyadmin and modify the config. default. php file. Find $ cfg ['servers'] [$ I] ['password'] = '',

Change to $ cfg ['servers'] [$ I] ['password'] = '000000 ′;

123456 is the password you want. after you restart mysql, the new password takes effect.

Step 1: log on to phpMyAdmin as an administrator account. generally, log on to phpMyAdmin as root.

Part 2: create a database for which permissions are to be set (this is not required if it already exists)

Fill in the database name and database code. I chose the "Chinese-Chinese simplified" encoding and click Create. The data will be ready.

Step 3: Create a management User

After creating the database, click the new database "sweiku.com" and click "permissions". a new page is displayed, and then click "add new user", as shown in figure

In this step, note that you do not need to select global permissions and then click execute directly.

Step 4: Set user permissions

Select the corresponding permissions and click execute

...