XAMPP: Solution to error when accessing phpmyadmin, xamppphpmyadmin_PHP tutorial

XAMPP: Solution to error when accessing phpmyadmin, xamppphpmyadmin

Source: http://www.ido321.com/1246.html

XAMPP (Apache+MySQL+PHP+PERL) is a powerful integrated software package for building XAMPP software stations. 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, the 3306 port 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 modified 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, you can directly enter the phpmyadmin management interface

This method is not very safe. Without verification, anyone can enter phpmyadmin to manage the 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 interface corresponding to cookie and http is not the same on Windows), I changed it to cookie, and the following will appear: Picture verification interface

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. Common parameter configurations are 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 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, you can use http and cookies;

PHP installation mode is CGI, you can use cookies.

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. (Not tested. , this comes from the documentation, I think you can just ignore it)

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

http://www.bkjia.com/PHPjc/915194.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/915194.htmlTechArticleXAMPP: Solution to error when accessing phpmyadmin, xamppphpmyadmin Source: http://www.ido321.com/1246. html XAMPP (Apache+MySQL+PHP+PERL) is a powerful XAMPP software website integration...