How to solve the error when accessing phpmyadmin

XAMPP (Apache+MySQL+PHP+PERL) is a powerful integrated software package for building XAMPP software sites. It is lightweight and easy to use. It provides the powerful phpmyadmin database management tool, allowing users to use and manage the database with ease. For the problem of not being able to open phpmyadmin locally, my solution is as follows:

MySQL has a default dedicated port: 3306, so if you have installed MySQL independently before, port 3306 is already occupied. When installing MySQL integrated with XAMPP, you must reset the independent port, otherwise you will not be able to access phpmyadmin. The error message I received is shown in the picture:

The modification method is also very convenient. Open the XAMPP control panel, find the config on the right side of mysql, click it, and the my.ini selection will appear. This is the mysql configuration file, as shown in the picture:

Of course I just changed the port, but I still can’t access it. You also need to modify the configuration file of phpmyadmin. There are two ways:

1. Solution to error when accessing phpmyadmin

1. Open the xampp directory (the default installation directory, if you modify it, please find the xampp installation directory), open the phpmyadmin directory, and find config.inc.php in the directory. My default configuration:

<span><?php <span>/*</span> <span> * This is needed for cookie based authentication to encrypt password in</span> <span> * cookie</span> <span> */</span> $cfg[<span>'blowfish_secret'</span>] = <span>'xampp'</span>; <span>/* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */</span> <span>/*</span> <span> * Servers configuration</span> <span> */</span> $i = 0; <span>/*</span> <span> * First server</span> <span> */</span> $i++; <span>/* Authentication type and info */</span> $cfg[<span>'Servers'</span>][$i][<span>'auth_type'</span>] = <span>'config'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'user'</span>] = <span>'username'</span>;            //mysql用户名
$cfg[<span>'Servers'</span>][$i][<span>'password'</span>] = <span>'password'</span>;       //mysql密码
$cfg[<span>'Servers'</span>][$i][<span>'extension'</span>] = <span>'mysqli'</span>;     //扩展配置，若访问出现没有配置mysqli等错误，加上这个。默认是有的
$cfg[<span>'Servers'</span>][$i][<span>'AllowNoPassword'</span>] = <span>true</span>;
$cfg[<span>'Lang'</span>] = <span>''</span>; <span>/* Bind to the localhost ipv4 address and tcp */</span> $cfg[<span>'Servers'</span>][$i][<span>'host'</span>] = <span>'127.0.0.1'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'connect_type'</span>] = <span>'tcp'</span>; <span>/* User for advanced features */</span> $cfg[<span>'Servers'</span>][$i][<span>'controluser'</span>] = <span>'pma'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'controlpass'</span>] = <span>''</span>; <span>/* Advanced phpMyAdmin features */</span> $cfg[<span>'Servers'</span>][$i][<span>'pmadb'</span>] = <span>'phpmyadmin'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'bookmarktable'</span>] = <span>'pma_bookmark'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'relation'</span>] = <span>'pma_relation'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'table_info'</span>] = <span>'pma_table_info'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'table_coords'</span>] = <span>'pma_table_coords'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'pdf_pages'</span>] = <span>'pma_pdf_pages'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'column_info'</span>] = <span>'pma_column_info'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'history'</span>] = <span>'pma_history'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'designer_coords'</span>] = <span>'pma_designer_coords'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'tracking'</span>] = <span>'pma_tracking'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'userconfig'</span>] = <span>'pma_userconfig'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'recent'</span>] = <span>'pma_recent'</span>;
$cfg[<span>'Servers'</span>][$i][<span>'table_uiprefs'</span>] = <span>'pma_table_uiprefs'</span>; <span>/*</span> <span> * End of servers configuration</span> <span> */</span> ?></span>

        Then add the following code after $cfg['Lang'] = ":

<span>$cfg[<span>'Servers'</span>][$i][<span>'port'</span>] = <span>'3307'</span></span>

Save, restart apache, enter localhost/phpmyadmin in the address bar, and you can directly enter the phpmyadmin management interface

This method is not very safe. Without verification, anyone can enter the phpmyadmin management database. Go back to the configuration file and find the following code:

<span>$cfg[<span>'Servers'</span>][$i][<span>'auth_type'</span>] = <span>'config'</span></span>

Change the config of the above code to cookie or http, and the verification interface will appear (the verification interfaces corresponding to cookie and http are not the same on Windows), I changed it to cookie, and the verification interface as shown will appear

2. This method also modifies the configuration file of phpmyadmin, but the path is different. Find the config.default.php file in phpmyadmin/libraries, which contains various configuration parameters of the server

<span>$cfg[<span>'Servers'</span>][$i][<span>'port'</span>] = <span>''</span>;</span>

Find this line of code, mine is on line 132. This is to configure the port. If the value is empty, it is the default 3306. After changing the value to 3307, save it, restart apache, and you can also access phpmyadmin

2. Detailed explanation of phpmyadmin configuration file

Open the config.default.php file found in phpmyadmin/libraries. Commonly used parameters are configured as follows

<span>$cfg[<span>'PmaAbsoluteUri'</span>] = <span>''</span>; <span>//phpmyadmin的访问网址 ，默认就行</span> $cfg[<span>'TranslationWarningThreshold'</span>] = 80; <span>//服务器端口</span> $cfg[<span>'Servers'</span>][$i][<span>'host'</span>] = <span>'localhost'</span>;<span>//mysql主机ip，如果mysql和该phpmyadmin在同一服务器，则按默认localhost</span> $cfg[<span>'Servers'</span>][$i][<span>'port'</span>] = <span>'3307'</span>; <span>//mysql端口，默认3306，保留为空即可</span> $cfg[<span>'Servers'</span>][$i][<span>'user'</span>] = <span>'root'</span>; <span>//mysql用户名</span> $cfg[<span>'Servers'</span>][$i][<span>'password'</span>] = <span>''</span>;<span>//密码</span> $cfg[<span>'Servers'</span>][$i][<span>'auth_type'</span>] = <span>'cookie'</span>; <span>//认证方式</span> <span>/*端口、用户名、认证方式等也可以再config.inc.php中配置，并且优先级高</span> <span>*$cfg['Servers'][$i]['auth_type'] = 'config';  这个是在config.inc.php的</span> <span>*配置，若不修改这个值，仍然可以直接访问phpmyadmin</span> <span>*/</span> $cfg[<span>'DefaultLang'</span>]=<span>'zh'</span>; <span>//设置默认语言</span> </span>

For the authentication method $cfg['Servers'][$i]['auth_type'] = 'cookie'; there are four values: cookie, http, HTTP, config

The config method is to enter the access URL of phpmyadmin to enter directly. There is no need to enter 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, the details are as follows:

          PHP installation mode is Apache, you can use http and cookies;

                                                                                                                                                            PHP installation mode is CGI, but cookies can be used.

In addition, in cookie mode, you can also set $cfg['blowfish_secret'] = "; (phrase password). As for what password to set, it is up to you, or you can ignore it. (I haven't tested it, this point comes from the documentation Explanation, I think you can just ignore it)

Next article: How to use PHP to generate PDF files in HTML

The above introduces how to solve the error when accessing phpmyadmin, including XAMPP and phpmyadmin. I hope it will be helpful to friends who are interested in PHP tutorials.