Shulou(Shulou.com)06/01 Report--

This article is about how to use phpmyadmin. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

create a database

In the main interface of phpMyAdmin, you can see the drop-down box with "language-language." We can select "Chinese-Chinese simplified" option in the drop-down box, and then there is a "Server Connection Calibration." We usually choose utf8_general_ci simplified Chinese encoding format to prevent garbled characters.

When the above settings are set, I will start creating the database below. Click on the database in the upper left to display the following interface:

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

modify the database

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

1. Enter the upper left 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 prompt information for creating a data table. Click the "Execute" button to enter the page for creating a data table structure.

2. In the upper right of the modification page, you can rename the database. Enter the database name in the text box of "rename the database:" and click "execute" to modify the database name successfully.

delete database

Also click the "Operation" button to enter the modification page. Under the "New Data Table" is to delete the database. Click to delete the database.

Thank you for reading! About "phpmyadmin how to use" this article is shared here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge, if you think the article is good, you can share it to let more people see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.