Simple usage tutorial of phpmyadmin

Create database

In the main interface of phpMyAdmin, you can see the drop-down box of "Language-languange", we can Select the "Chinese-Chinese simplified" option, and then there is a "Server connection proofreading". We generally choose the utf8_general_ci simplified Chinese encoding format to prevent garbled characters.

After the above settings are completed, I will start to create the database. Click on the database in the upper left corner and the following interface will appear:

Then enter your own database name in the text box, ours here is "php.cn", although we have set this encoding format at the beginning, but just in case, we can choose it again here "utf8_general_ci", then click the create button and then you can see the database you created in the left column, as shown below:

Modify database

In the database management interface (pictured above), there is an "Operation" button. Click to enter the page for modifying the operation database.

1. Enter the upper left corner of the modification page to create a data table for the current database. Enter the name of the data table to be created and the total number of fields in the two text boxes under the create data table prompt information, and click Click the "Execute" button to enter the create data table structure page.

2. You can rename the database in the upper right corner of the modification page. Enter the database name in the text box of "Rename the database to:" and click "Execute" to successfully modify the database name.

Delete database

Also click the "Action" button to enter the modification page, just below "New Data Table" Delete the database, click to delete the database

Recommended related articles and tutorials:phpmyadmin tutorial

The above is the detailed content of Simple usage tutorial of phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!