How to install and configure phpmyadmin in linux system

1. Install the phpMyAdmin graphical management tool

Install phpMyAdmin under the Linux operating system and copy the downloaded software package "phpMyAdmin-2.11.5-all -languages.rar" decompress it to the root directory of the configuration environment. For ease of use, you can rename the decompressed folder to phpMyAdmin.

The operation in command mode is as follows:

mv phpMyAdmin-2.11.5-all-languages.rar/var/ww/html
tar zvxf phpMyAdmin-2.11.5-all-languages.rar
mv phpMyAdmin-2.11.5-all-languages phpMyAdmin

Extract the downloaded software package to the /var/www/html/ directory through the above three commands, so as to Complete the installation of the phpMyAdmin graphical management tool.

2. Configure the phpMyAdmin graphical management tool

Configure in the config.inc.php file in the phpMyAdmin directory, and change the configuration of the following parameters.

//将参数PmaAbsoluteUri 的值设定为phpMyAdmin 所处的位置:
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin';

$cfg['blowfish_secret']='cookie'; //设定访问方式为Cookie

$cfg['Servers'][$i]['host'] = 'localhost'; //设定MySQL 所在的主机名或IP 地址
$cfg['Servers'][$i]['auth_type'] = 'http'; //设定进入phpMyAdmin 管理MySQL 的方式
$cfg['Servers'][$i]['user'] = 'root'; //设定管理MySQL 的账号
$cfg['Servers'][$i]['password'] = 'root'; //设定管理MySQL 的密码

After the parameter settings are completed, save the file and restart the Apache server.

Enter "http://localhost/phpMyAdmin/" in the address bar of the browser to open the phpMyAdmin graphical management main page for database operations.

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of How to install and configure phpmyadmin in linux system. For more information, please follow other related articles on the PHP Chinese website!