Learning the MySQL visual management tool phpMyAdmin

We have learned how to use mysql in a windows environment, but there is still a problem. It is often inconvenient for us to use the cmd command window to operate mysql. Is there a visual and easy-to-operate tool? The answer is yes, phpMyAdmin is one of them. This article introduces how to use phpMyAdmin to operate mysql. I hope it will be helpful to students in need.

1. Use the search engine to search or download the latest version of phpMyAdmin from the phpMyAdmin official website. Please note that we usually download code files from the official website (different from .exe which can be installed directly). Such files include One benefit: Just copy it directly to the corresponding folder after downloading:

2. Rename the decompressed file to phpMyAdmin and copy it to the first place we learn PHP In the Apache24\htdocs\ directory created in the lesson:

#3. Open the config.default.php file in the Apache24\htdocs\phpMyAdmin\libraries directory and modify the mysql user name Or password (this is described in the second lesson of PHP learning):

4. Open the configuration file php in the php directory. ini, modify the following parameters:

(1) Open the required expansion file (";" is a comment, remove it to open it);

(2) Set the expansion file access directory (very important , otherwise the corresponding expansion file cannot be found);

The following figure shows one of the errors when the extension is not enabled:

5. Restart apache, enter "http://localhost/phpMyAdmin/index.php" in the browser, enter the user name and password, and you can log in:

6. In this way, we can operate the database (table) more efficiently and conveniently. Start your own mysql journey, (￣▽￣)"

Notes

You need to restart apache after modifying php.ini

The above is the detailed content of Learning the MySQL visual management tool phpMyAdmin. For more information, please follow other related articles on the PHP Chinese website!