phpmyadmin is a mysql management tool. After installing this tool, you can directly manage mysql data through web without executing system commands to manage it. It is very suitable for database managers who are not familiar with database operation commands. Here I will talk about how to install this tool:
1. First download phpmyadmin online, and then decompress to the root directory of the local server you can access, such as the www directory of apache.
2. Configure the config file
Open the file under libraries, find the following items in turn, and configure it according to the instructions:
A. Access URL
$cfg['PmaAbsoluteUri'] = '';Fill in the access URL of phpmyadmin here. My directory is "127.0.0.1/phpMyAdmin/", which depends on the actual decompression situation.
Host information
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
Fill in the IP address of the server where localhost or mysql is located. If mysql and phpmyadmin are on the same server, press the default localhost
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
If the mysql port is default 3306, it can be left empty
Username and password
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user accesses the mysql username used by phpmyadmin
fg['Servers'][$i]['password'] = ''; // MySQL password (only needed corresponds to the password of the above mysql username
D. Authentication method
$cfg['Servers'][$i]['auth_type'] = 'cookie';
There are four modes to choose from here: cookie, http, HTTP, config
The config method is to enter the access URL of phpmyadmin and you can enter directly without entering the username and password. It is not safe and is not recommended.
When this item is set to cookie, http or HTTP, logging in to phpmyadmin requires a data username and password for verification, as follows:
The PHP installation mode is Apache, and you can use http and cookies;
PHP installation mode is CGI, you can use cookies
E. Settings of phrase password (blowfish_secret)
$cfg['blowfish_secret'] = '';
If the authentication method is set to cookie, you need to set the phrase password.
Missing mysqli extensionSolution:
1. Check whether ;extension=php_mysqli.dll is enabled
2. Check whether the extension_dir address points to the ext directory of the php directory
3. Check whether lib_mysql.dll has been copied to the Windows directory
4. Check whether the php_mysqli.dll file exists in the ext directory of the php installation directory
5. Check the php detailed page <?php phpinfo(); ?> to see if mysql and mysqli have been started
Just make changes based on your own situation. For example, my machine will report an error because of the third reason. It's OK to place the lib_mySQL.dll below MySQL\bin in the Windows directory!
Note: My operating system is win7.