phpMyAdmin Configuration and attention issues (2011-01-19-11:14:54)

1. Download FirstPHPmyadmin installation package,http://www.phpmyadmin.net 
   
2, unzip a separate directory (you can customize the directory name)
  
3. Locate the/libraries/config.default.php file (the old version is the config.inc.php file under the root directory), and use WordPad (do not use Notepad, which is UTF8 encoding) for editing.
  
4. Find $cfg [' Pmaabsoluteuri ']
Modify the URL of the phpmyadmin that you will upload to the space
such as: $cfg [' pmaabsoluteuri '] = ' http://jwc.jxatei.net:8080/phpMyAdmin/';
  
5. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; (usually with default, with exception, without modification)
  
6. Find $cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';
Debug in your own machine with config; if the space on the network with a cookie, here we have already added the URL in the previous, the change to a cookie, here is recommended to use cookies.
  
7, find $cfg [' Servers '] [$i] [' user '] = ' root ';//MySQL User (username, usually here just fill in a few letters on it; In special cases, use root in your own machine, on the Internet generally for your FTP user name, The virtual hosting provider tells you, generally do not modify.)
  
8. Find $cfg [' Servers '] [$i] [' password '] = ';//MySQL password (only needed left blank)
  
9, find $cfg [' Servers '] [$i] [' only_db '] = ';//If set to a db-name, only (you have only one data set, set as your database name; If you want to build a server, then leave the suggestion blank)
  
10, look for $cfg [' defaultlang '] = ' zh '; (here is the language of choice, en for the meaning of Simplified Chinese)
        
11, find $cfg[' Blowfish_secret ', please set your website's cookie (the cookie is the domain name that accesses phpMyAdmin) in $cfg[' blowfish_secret '] = ";, for example: $cfg [ ' Blowfish_secret '] = ' http://jwc.jxatei.net:8080/phpMyAdmin ';.
     
12, set up after the save, can now upload to the network space, browseHttp://jwc.jxatei.net:8080/phpMyAdminTest it for a moment.
  

unable to load MySQL extension, please check PHP configuration (MySQL database not supported) (Reason and workaround)
  
One, run the phpMyAdmin program tip "Unable to load the MySQL extension, check the PHP configuration" workaround as follows:
Answer: The configuration PHP in the win system does not find PHP extension settings mbstring solution
The specific solution is to copy the Php_mbstring.dll under the X:\PHP\EXT folder to the System X:\WINDOWS\system32 folder [X represents the partition on your computer] modify X:\WINDOWS\ php.ini file found; E Xtension=php_mbstring.dll, remove, save PHP. INI to restart IIS and then open phpMyAdmin.
      
Second, unable to load the mcrypt extension, <br/> Please check the PHP configuration

1, the MySQL database is not installed correctly, in the system service MySQL related services did not start (please check the correct way to install MySQL)
2, in the system system32 (C:\WINDOWS\SYSTEM32) directory is missing Libmcrypt.dll file, the solution is to find the PHP directory Libmcrypt.dll, and copy Libmcrypt.dll to c \ Windows \system32 directory, and then restart the Web service.
3, in the C:\windows directory of the php.ini file, there is no "; Extension=php_mcrypt.dll" in the previous ";" removed, so the function cannot be used, the workaround is to open the php.ini file
to find; Extension=php_mcrypt.dll.
Change to Extension=php_mcrypt.dll//Remove the front; make it effective "

phpMyAdmin Configuration and attention issues (2011-01-19-11:14:54)