phpMyAdmin Common Error Solutions

1, the permission is too large, the prompt configuration file can not have write permission

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M01/93/1B/wKiom1kILU7S0vlEAAAwBGDb7nY757.png-wh_500x0-wm_ 3-wmp_4-s_2907842399.png "title=" 1.png "alt=" Wkiom1kilu7s0vleaaawbgdb7ny757.png-wh_50 "/>

I get this error when I try to access localhost/phpmyadmin:

Wrong permissions on configuration file, should is not being world writable!

Workaround:

sudo chmod 755/opt/lampp/phpmyadmin/config.inc.php

ok,success!

2. Disclaimer: MySQL and phpMyAdmin are not on the same host

• "Unable to log on when logging in MySQL Server ".

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/78/AC/wKiom1aBAWjz6kFPAAAaveLFFN4317.png "title=" 1.png " alt= "Wkiom1abawjz6kfpaaaavelffn4317.png" style= "Padding:0px;margin:0px;vertical-align:top;border:none;float: none; "/>

Workaround:

If MySQL and phpMyAdmin are not on the same host, you need to modify two of the configuration file phpmyadmin/libraries/config.default.php:

//allow Login to any user entered server in cookie Based authentication configuration allows you to log into any server that uses cookies.

$cfg [' allowarbitraryserver '] = true;

//mysql hostname or IP address

$cfg [' Servers '] [$i] [' host '] = ' 172.16.0.35 '; //This item can also not be modified

After modifying the login phpmysql will be more "server", enter the MySQL server IP (note: Is the HTTP server access to MySQL IP address):

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/78/AC/wKiom1aBAWiwoKYQAABNnbuIIvY115.png "title=" 2.png " alt= "Wkiom1abawiwokyqaabnnbuiivy115.png" style= "Padding:0px;margin:0px;vertical-align:top;border:none;float: none; "/>

3. After login prompt "configuration file now requires a phrase password":

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/78/AC/wKiom1aBAWmzKRAdAAAgfGO-KFU997.png "title=" 3.png " alt= "Wkiom1abawmzkradaaagfgo-kfu997.png" width= "650" style= "Padding:0px;margin:0px;vertical-align:top;border: None;float:none; "/>

Workaround:

Modify phpmyadmin/config.inc.php:

$cfg [' blowfish_secret '] = ' Oimec '; //Oimec Here is any phrase that acts as a key for the AES encryption algorithm when the cookie is authenticated

4. After login prompt "phpMyAdmin advanced features have not been set, some functions are activated." ”：

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/78/AC/wKiom1aBAWmhBcr-AAAu7S4oAq0915.png "title=" 4.png " alt= "Wkiom1abawmhbcr-aaau7s4oaq0915.png" style= "Padding:0px;margin:0px;vertical-align:top;border:none;float: none; "/>

Workaround:

Import the Phpmyadmin/sql/create_tables.sql script file from the Web server into execution from the phpMyAdmin.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/78/AC/wKiom1aBAWvTVNtrAACwDEer2QA609.png "title=" 5.png " alt= "Wkiom1abawvtvntraacwdeer2qa609.png" width= "650" style= "Padding:0px;margin:0px;vertical-align:top;border: None;float:none; "/>

Log in to phpMyAdmin again, view the silent, and create the "phpMyAdmin" database.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/78/AB/wKioL1aBAYbwwTCOAABL0AcAAFw131.png "title=" 6.png " alt= "Wkiol1abaybwwtcoaabl0acaafw131.png" style= "Padding:0px;margin:0px;vertical-align:top;border:none;float: none; "/>

phpMyAdmin Common Error Solutions