Phpmyadmin configuration in CentOS

Install phpmyadmin on the development and testing machine web, and test mysql locally:

Mysql 5.0.77, start the service, set the mysql account password, initialize... Phpmyadmin3.5.3 unzip the installation directory:/var/www/html/xx/hub/mydb VM access domain name: mydb. hub. xx. modify the comphpmyadmin configuration file: Open the config under the libraries directory. default. PHP file 1) visit the website

 
 

  
  
$cfg['PmaAbsoluteUri'] = 'mydb.hub.xx.com'; 
 
 

Enter the phpMyAdmin access URL. 2) mySQL host information

 
 

  
  
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address 
 
 

Enter the ip address of the localhost or MySQL server. If MySQL and phpMyAdmin are on the same server, press the default localhost

 
 

  
  
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port 
 
 

MySQL port. The default value is 3306. leave it blank. If you use another port during MySQL installation, enter it here. 3) MySQL user name and password

 
 

  
  
$cfg['Servers'][$i]['user'] = 'root'; 
 
 

Enter the MySQL user name used by MySQL to access phpMyAdmin. The default value is root.

 
 

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

Enter the password corresponding to the above MySQL user name. 4) authentication method

 
 

  
  
$cfg['Servers'][$i]['auth_type'] = 'cookie'; 
 
 

For security considerations, we recommend that you enter the cookie here in four modes: cookie, http, HTTP, and configconfig. You can enter the phpMyAdmin access URL directly, you do not need to enter 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 use the data username and password for verification to log on to phpMyAdmin. For details, refer to the following: PHP installation mode is Apache, and http and cookie can be used; the PHP installation mode is CGI. You can use cookies. 5) set the phrase password (blowfish_secret)

 
 

  
  
$cfg['blowfish_secret'] = '';<P></P>
 
 

If the authentication method is set to cookie, you need to set the phrase password. leave it blank. Otherwise, an error will be prompted when you log on to phpMyAdmin.

This article is from the "E people space" blog, please be sure to keep this source http://iceeggplant.blog.51cto.com/1446843/1107824