How to configure phpmyadmin when using it for the first time-phpMyAdmin-php.cn

How to configure phpmyadmin when using it for the first time

王林

Release： 2019-12-13 09:15:52

Original

2744 people have browsed it

How to configure phpmyadmin when using it for the first time

Download phpMyAdmin and unzip it, open the config.default.php file in the libraries directory, find the following items in order, and configure them according to the instructions.

(1) Access URL

$cfg[&#39;PmaAbsoluteUri&#39;]= &#39;&#39;; //这里填写 phpMyAdmin 的访问网址

Copy after login

(2) MySQL host information

$cfg[&#39;Servers&#39;][$i][&#39;host&#39;]= &#39;localhost&#39;; // MySQL hostname or IP address

Copy after login

Fill in localhost or the server where MySQL is located IP address, if MySQL and the phpMyAdmin are on the same server, press the default localhost

$cfg[&#39;Servers&#39;][$i][&#39;port&#39;]= &#39;&#39;; // MySQL port - leave blank for default port

Copy after login

MySQL port, the default is 3306, just leave it empty. If you use other ports when installing MySQL, you need to here fill in.

(3) MySQL user name and password

$cfg[&#39;Servers&#39;][$i][&#39;user&#39;] = &#39;root&#39;; // 填写 MySQL 访问 phpMyAdmin 使用的 MySQL 用户名，默认为 root
fg[&#39;Servers&#39;][$i][&#39;password&#39;] = &#39;&#39;; // 填写对应上述 MySQL 用户名的密码

Copy after login

(4) Authentication method

$cfg[&#39;Servers&#39;][$i][&#39;auth_type&#39;] = &#39;cookie&#39;;

Copy after login

Considering security factors, It is recommended to fill in cookies here. 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:

The PHP installation mode is Apache, and http and cookies can be used;

PHP installation mode is CGI and cookies can be used.

(5) Setting of phrase password (blowfish_secret)

$cfg[&#39;blowfish_secret&#39;] = &#39;&#39;

Copy after login

If the authentication method is set to cookie, you need to set a phrase password. What password to set is up to you. , cannot be left blank here, otherwise the error shown in the figure below will be prompted when logging in to phpMyAdmin.

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of How to configure phpmyadmin when using it for the first time. For more information, please follow other related articles on the PHP Chinese website!