XAMPP: solution for accessing phpmyadmin error, xamppphpmyadmin_PHP tutorial-php Tutorial

XAMPP: solution for accessing phpmyadmin error, xamppphpmyadmin. XAMPP: solution for accessing phpmyadmin error. xamppphpmyadmin Source: www.ido321.com1246.html XAMPP (Apache + MySQL + PHP + PERL) is a powerful XAMPP software station integrated with XAMPP: solution for accessing phpmyadmin error, xamppphpmyadmin

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

XAMPP (Apache + MySQL + PHP + PERL) is a powerful software integration package for XAMPP software stations. it is lightweight and easy to use. It provides powerful phpmyadmin database management tools, allowing users to easily use and manage databases. My solution is as follows:

MySQL has a default dedicated port: 3306. Therefore, if you have installed MySQL independently, Port 3306 is occupied. When installing MySQL integrated with XAMPP, you must reset the independent port. Otherwise, you cannot access phpmyadmin. the error message I receive is shown in the following figure:

The modification method is also very convenient. open the control panel of XAMPP, find the config on the right of mysql, and click it. The "my. ini" option is displayed, which is the configuration file of mysql,

Of course, it's just a port change. I still cannot access it. You also need to modify the phpmyadmin configuration file. There are two ways:

I. solutions to access phpmyadmin errors

1. open the xampp Directory (the default installation directory), open the phpmyadmin directory, and find config. inc. php, my default configuration:

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

$cfg['Servers'][$i]['port'] = '3307'

Save and restart apache. enter localhost/phpmyadmin in the address bar to directly access the phpmyadmin management interface.

This method is not safe and has not been verified. anyone can go to phpmyadmin to manage the database. Return to the configuration file and find the following code:

$cfg['Servers'][$i]['auth_type'] = 'config'

If you change the config of the above code to cookie or http, the verification interface will appear (the verification interface for cookie and http is different on windows). I changed it to cookie, the verification page appears.

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

$cfg['Servers'][$i]['port'] = '';

Find this line of code. in line 132, the port is configured. if the value is null, the default value is 3306. change the value to 3307, save the code, and restart apache, you can also access phpmyadmin.

II. phpmyadmin configuration file details

Open phpmyadmin/libraries and find the config. default. php file. the common parameter configuration is as follows:

$ Cfg ['pmaabsoluteuri '] = ''; // phpmyadmin URL. the default value is $ cfg ['translationwarningthreshold'] = 80; // server port $ cfg ['servers'] [$ I] ['host'] = 'localhost'; // mysql host ip address. if mysql and phpmyadmin are on the same server, press the default localhost $ cfg ['servers'] [$ I] ['port'] = '000000'; // mysql port. the default value is 3307, leave it blank. $ cfg ['servers'] [$ I] ['user'] = 'root '; // mysql username $ cfg ['servers'] [$ I] ['password'] = ''; // password $ cfg ['servers'] [$ I] ['auth _ type'] = 'cooker '; // The authentication method/* Port, user name, and authentication method can also be configured. inc. php configuration, and the priority is high * $ cfg ['servers'] [$ I] ['auth _ type'] = 'config'; this is in config. inc. php * configuration. if this value is not modified, you can still directly access phpmyadmin */$ cfg ['defaultlang '] = 'zh'; // set the default language

The authentication method $ cfg ['servers'] [$ I] ['auth _ type'] = 'cooker'; has four values: cookie, http, HTTP, config

In config mode, you can directly access the phpmyadmin access url without entering the user name and password. it is insecure and is not recommended.

When this option is set to cookie, http, or HTTP, you need to verify the data username and password to log on to phpmyadmin. The details are as follows:

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

The PHP installation mode is CGI. you can use cookies.

In cookie mode, you can also set $ cfg ['blowfish _ secret'] = "; (phrase password). you have to decide why to set the password, or ignore it. (I have never tested it. this is from the instructions in this document. I don't think it's enough to ignore it)

Next Article: how to use PHP to generate PDF files in HTML

Http://www.ido321.com/1246.html XAMPP (Apache + MySQL + PHP + PERL) is a powerful build XAMPP software site integration...