Home >Backend Development >PHP Tutorial >phpmyadmin MySQL encryption configuration method_PHP tutorial
Take version phpMyAdmin-2.6.1.tar.gz as an example
First unzip phpMyAdmin-2.6.1.tar.gz to /usr/local/apache2/htdocs,
to get the folder phpMyAdmin -2.6.1, rename it to phpmyadmin, (this will make it easier in future operations).
Go to the phpmyadmin folder and use the vim command to open config.inc.php.
That is, #vim config.inc.php.
Encryption only needs to modify two parts:
1. Find $cfg['Servers' ][$i]['auth_type'] = 'config'; (line 83), change config to http.
For example, mine is: $cfg['Servers'][$i]['auth_type'] = 'http';
2. Fill in the next two lines with the database username and The password is just
For example, mine is: $cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$ i]['password'] = '123456';
MySQL encryption in Phpmyadmin is complete!
****************************************** ***************
There is one more thing that needs to be modified during the Phpmyadmin configuration process:
Find $cfg['PmaAbsoluteUri'] = ''; (Line 39)
Fill in the absolute address of your server's phpmyadmin at the end
For example, mine is:
$cfg['PmaAbsoluteUri'] = ' http://10.10.19.167/phpmyadmin';
This way the phpmyadmin configuration is completed, easy! (Note: Different versions may be different)