PhpMyAdmin installation and configuration process and troubleshooting

This is a very sincere technical article, which is referenced here. it is also a backup to prevent the original text from being lost or it is too difficult to find it back in the vast network. Debugging the PHP database Mysql today and installing the phpMyAdmin database management software on the computer of the organization were simple, but there were several problems.

This is a very sincere technical article, which is referenced here. it is also a backup to prevent the original text from being lost or it is too difficult to find it back in the vast network.

Today, I debugged the PHP database Mysql and installed phpMyAdmin database management software on my computer. it was a very simple task, but there were several problems:

1/the mcrypt extension cannot be loaded. check the PHP configuration;

2. the configuration file now requires a top secret phrase password (blowfish_secret );

3/#2003-the server does not respond.

The latest phpMyAdmin version has been updated to 2.11.5.1. many of the configuration methods circulating on the Internet are earlier versions and are not suitable for the new version; so flymorn also listed the configuration steps of phpMyAdmin2.11.5.1 below. for the convenience of switching and debugging PHP, I used windows and local debugging.

1. first download the phpMyAdmin installation package:

To foreign official website http://www.phpmyadmin.net, click the navigation bar on the downloads page, select “all-languages.zip version to download to local, decompress the file to the system specified virtual root directory phpmyadmin folder (can be customized folder name ), for example, the local storage location of flymorn is D: \ www \ phpmyadmin.

2. find the/libraries/config. default. php file in the phpmyadmin folder (the old version is the config. inc. php file under the root directory) and open it with a tablet that supports UTF-8 encoding for editing.

3. search for $ cfg ['pmaabsoluteuri ']

Modify the phpMyAdmin URL that you will upload to the space

For example, $ cfg ['pmaabsoluteuri '] = 'http: // www.piaoyi.org/phpmyadmin /';

Here, because I am local debugging, I changed it to $ cfg ['pmaabsoluteuri '] = 'http: // localhost/phpmyadmin /';

Note: Do not miss the last backslash (/) and http at the beginning.

4. search for $ cfg ['servers'] [$ I] ['host'] = 'localhost'; (the default value is usually used, and there are exceptions. you do not need to modify the value)

5. find $ cfg ['servers'] [$ I] ['auth _ type'] = 'config ';

Debug config in your own machine; if the space on the network uses cookies, now that we have added a URL before, we will change it to a cookie.

My personal suggestion: both on the local network and on the network, we recommend that you set the cookie to be the first in security.

At the same time, when the auth_type value is set to cookie, there is also a need to make the appropriate changes:

$ Cfg ['blowfish _ secret'] = '';

Change to: $ cfg ['blowfish _ secret'] = 'www .piaoyi.org ';

Www.piaoyi.org can be defined at will, with no more than 46 characters. If this field is left blank, the above 2nd error will occur: "The configuration file now requires a top secret phrase password (blowfish_secret )".

6. search for $ cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user (user name, root in your machine; this is generally your ftp user name on the Internet, which the VM provider will tell you. do not change it)

7. search for $ cfg ['servers'] [$ I] ['password'] = '2016 '; // MySQL password (123456 changed to the user password used to connect to your MYSQL database)

8. find $ cfg ['defaultlang '] = 'zh'. (select the language. zh indicates the meaning of simplified Chinese) $ cfg ['defaultcharset'] = 'gb2312)

Now, phpMyAdmin has been configured. you can enable http: // localhost/phpmyadmin/to access the convenient and convenient graphical management software phpMyAdmin. For other options in the configuration file that are not mentioned in this article, you don't have to worry about it or modify it. The specific operations on phpMyAdmin are not covered in this article. However, the graphical interface is easy to understand and can be used for a moment (refer ).

Next, let's talk about several problems that flymorn encountered when installing and configuring phpMyAdmin.

-- First problem: "The mcrypt extension cannot be loaded. check the PHP configuration ".

1. the Mysql database is not correctly installed, and Mysql-related services are not started in the system service.

2. libmcrypt is missing in the system32 (C: \ windows \ system32) Directory of the system. dll file. the solution is to find libmcrypt under the php directory. dll, and libmcrypt. copy the dll to the C: \ windows \ system32 directory and restart the Web service.

3. PHP under the php directory. in the INI file, the previous ";" in "; extension = php_mcrypt.dll" is not removed, so the corresponding function cannot be used. the solution is to open php. ini file, find it; replace extension = php_mcrypt.dll with extension = php_mcrypt.dll // remove the previous one to make it take effect.

4. the Mysql Directory has no read permission. the correct directory permission is as follows:

Full administrator control

Full system control

User reading and running

All other user permissions can be deleted (or retained, but the security is not high, it is recommended to delete), and then restart the MYsql service and Web service (it is recommended to modify this item and then restart the server ).

5. if none of the above methods works, use this method: desktop> My Computer> right-click Properties> Advanced> environment variables> System variables> New

Name: phpdir

Value: C: \ php (what directory is your PHP)

-- Second problem: "mysql extension cannot be loaded. check the PHP configuration"

Copy libmySQL. dll in the PHP directory to: c: \ windows \ system32, and restart APACHE.

-- Third question: "The configuration file now requires a top secret phrase password (blowfish_secret )"

Make sure that the correct settings are made in the config. default. php file:

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';

At the same time

$ Cfg ['blowfish _ secret '] = 'www .piaoyi.org'; // (this value can be written at will, but cannot be left blank)

In fact, this problem is really depressing. if I did it according to the configuration method I mentioned above, it would not prompt this error. After more than two hours of modifying the config. default. php configuration file, I always indicated this error, almost reaching the edge of the crash.

Then, Ling Guang suddenly found that when I changed the auth_type authentication method to http and changed it to config, this error always occurred when I opened the page. that is to say, the authentication mode has changed and does not work for phpmyadmin, is phpmyadmin affected by other configuration files?

I immediately came to the phpmyadmin root directory and found that a config. sample. inc. php file exists under the root directory, and a config. inc. php file exists !! This is a configuration file of the old version. it turns out to be a ghost of this file. Immediately delete config. inc. php and go to the Debugging Page. the error disappears! Solve the problem.

It seems that the config. inc. php configuration file priority ratio/libraries/config. default. the php configuration file is high. The system first calls the configuration file in the root directory, and then the configuration file in the libraries folder. ai, this problem has been so long and I am sorry. The solution is always done. just breathe a sigh of relief.

-- Fourth question: "#2003-the server has not responded ".

Most of these problems occur when the MYSQL database is not started. we recommend that you directly start MYSQL in the control panel-management tools-service. You can run a process such as running mysqld-nt.exe on the task manager. If yes, mysql is started.

-- Fifth problem: "No PHP extension settings are found ".

Modify the PHP. INI file under C: \ WINDOWS \ and find; extension = php_mbstring.dll; remove it, save PHP. INI, and restart Apache.

These problems will not happen. However, for a newbie, if he finds a solution for the first time, he usually searches everywhere. if a lot of methods on the Internet are not applicable, he may feel helpless. I suggest you read the document carefully and refer to the solutions provided by our predecessors. although they may not be applicable, they will inspire you. If you have more hands-on and more tests, you can find it difficult if you have no problems.

Allow ie to support the background color of RGBa

RGBa is a method to declare a color that contains a transparent effect in CSS. with RGBa, we can set an element to transparent without affecting its child elements. However, not all browsers support the background color of RGBa, which is not supported by many old versions of Internet Explorer. Fortunately, Internet Explorer supports conditional annotations, we can discard RGB and use a private CSS Filter from IE to achieve the same effect. Code:

Click to view online demo

DXImageTransform. microsoft. the value of startColorstr in the gradient filter is in the format of # AARRGGBB. AA indicates the hexadecimal format of opacity, 00 indicates completely transparent, and FF indicates completely transparent, the decimal range is 0 ~ 255. The remaining RRGGBB is the hexadecimal code of the color. In the example, background: rgba (125, 0, 0,. 3); indicates a red background with a 30% opacity. How can we convert the opacity of 30% to hexadecimal notation? It is very simple. calculate the # AA decimal x, x/255 = 3/10, and obtain x = 3*255/10. then convert x to hexadecimal format, which is about 4B.

The RGBa color can also be used for border. However, different browsers have different support for border RGBa, but the only difference is that Firefox will overlap at the corner of border, for example, the transparency is 0.4, in Firefox, the transparency of the Four Corners will change to 0.8, but non-FF browsers supporting RGBa will not.