Although it may not be used when developing and debugging the system locally, when placing a Mysql database in a remote virtual host in the future, Mysql GUI tools such as phpmyadmin will inevitably be used. Therefore, familiarize yourself with how to use it locally. It is also necessary.
Then let’s start the installation and configuration now:
1. Generally, the PHPMyAdmin downloaded from the Internet is a compressed package, and we release it into the htdocs directory, such as htdocsphpmyadmin.
2. Open the phpmyadmin directory and see if there is a config.sample.inc.php file in this directory. If it exists, rename it to config.inc.php. (Depending on the version, there may be a config.inc.php file directly, so there is no need to change the name. It is also possible that there is no config.sample.inc.php or config.inc.php at all. Then we will go to the phpmyadminlibraries directory and change the config. .default.php is copied to the phpmyadmin directory and renamed config.inc.php).
3. Open the config.inc.php file (you can use WordPad) and find $cfg['blowfish_secret'] = ''; and $cfg['Servers'][$i]['auth_type'] = 'cookie' ;, if the value of $cfg['Servers'][$i]['auth_type'] is a cookie as seen earlier, then we must put any in the quotes of $cfg['blowfish_secret'] = '' Write a string of characters, which you can understand as an authentication code. For example $cfg['blowfish_secret'] = 'sunec'. Save and exit.
At this point, the installation and configuration of phpmyadmin is over. Enter the browser and enter http://localhost/phpmyadmin/main.php in the address bar. (The path here is determined based on the directory name where you unzipped phpmyadmin in htdocs. ), if everything goes well, a screen for you to enter your username and password should appear on the page. Enter your username and password (Mysql username and password), and then enter the main interface of phpmyadmin. As for how to use it, I won’t go into it here for the time being. You can explore it yourself first.
The above introduces the phpmyadmin configuration PHPMyAdmin quick configuration method, including the content of phpmyadmin configuration. I hope it will be helpful to friends who are interested in PHP tutorials.