Illustration of phpMyadmin creating database and setting user permissions_PHP tutorial

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 the user's very high permissions, such as ROOT permissions. Let me introduce it to you below.

First configure the phpmyadmin configuration, otherwise you will not be able to log in.

Then you need to enter the libraries directory under the phpmyadmin directory and modify the config.default.php file. Find $cfg['Servers'][$i]['password'] = ‘ ‘,

Modify to $cfg['Servers'][$i]['password'] = ’123456′;

123456 is the password you want. The new password will take effect after restarting mysql.

Step 1: Log in to phpMyAdmin with an administrator account, usually log in as root

Part 2: Create the database to which permissions are to be set (not necessary if it already exists)

Fill in the database name and database encoding. I chose the "Chinese-Chinese simplified" encoding, click Create, and the data will be created

Step 3: Create an administrative user

After creating the database, click on the new database sweiku.com, click Permissions, a new interface will appear, and then click Add new user, as shown above

In this step, pay special attention to the fact that global permissions do not need to be selected, and then click Execute directly.

Step 4: Set user permissions

Select the corresponding permissions and click Execute

http://www.bkjia.com/PHPjc/630719.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630719.htmlTechArticlephpmyadmin is a very good WEB management software for mysql database. If you want to create a database and set user permissions, we It is necessary to operate the user's very high permissions, such as ROOT permissions. Below I...