How to install phpmyadmin

First download the corresponding phpmyadmin version according to your own PHP and MYSQL version from the download page of phpmyadmin's official website.

The red box in the figure indicates that this version supports the PHP version and the MYADL version.

For example, this version supports PHP5.3 and MYSQL5.5. (php video tutorial)

#After downloading and decompressing, upload the phpMyAdmin folder directly to the root directory of the website.

Open the phpMyAdmin/libraries/config.default.php file for editing.

Find the following variables and edit

$cfg['PmaAbsoluteUri'] = 'http://www.simple.com/phpmyadmin';//这里填写phpmyadmin的访问网址 
$cfg['Servers'][$i]['host'] = 'localhost'; // 填写localhost或mysql所在服务器的ip地址，

If mysql and the phpmyadmin are on the same server, press the default localhost

$cfg['Servers'][$i]['port'] = ''; // mysql端口，如果是默认3306，保留为空即可 
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user 访问phpmyadmin使用的mysql用户名 
fg['Servers'][$i]['password'] = ''; // MySQL password (only needed对应上述mysql用户名的密码 
$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 to enter directly without entering the user name and password. It is unsafe and 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:
PHP installation mode is Apache, http and cookies can be used;
PHP installation mode For CGI, you can use cookies

After the configuration is completed, if the browser enters http://127.0.0.1/phpmyadmin to log in

If it shows that you cannot log in to the server,

will $ cfg['Servers'][$i]['host'] = 'localhost';

Changed to $cfg['Servers'][$i]['host'] = '127.0.0.1' ;

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