How to build a database in phpstudy

1. Click to open the phpstudy software, and then click mySQL Manager.

#2. Enter the PHPmyadmin login interface. The default account and password are root.

#3. Then, click the database and enter the required data name, for example: new, get it randomly.

4. Then, click Users and click Next to add users.

#5. Fill in the user name, select local as the host, and set the password to 2. One is to set it yourself, and the other is to use the system to generate it. Then click Add User.

#6. After adding successfully, you can see it in the image below and click Edit Permissions.

#7. You will enter the graphical interface, but do not set permissions here.

#8. Scroll the scroll bar to this point, and then select the name you just set.

#9. You will quickly enter the permission setting interface, select data and structure, manage all, and then click Execute.

#10. After completing the above steps, building the database is completed. The effect is as follows.

Recommended tutorial: phpStudy quick entry video tutorial

The above is the detailed content of How to build a database in phpstudy. For more information, please follow other related articles on the PHP Chinese website!