Shulou(Shulou.com)06/02 Report--

1. The permission is too large, prompting that the configuration file cannot have write permission.

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

Wrong permissions on configuration file, should not be world writable!

Solution:

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

OK,success!

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

Prompt "unable to log in to MySQL server" when logging in.

Solution:

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

/ / whether the allow login to any user entered server in cookie based authentication configuration allows you to log in to any server that logs in using cookie.

$cfg ['AllowArbitraryServer'] = true

/ / MySQL hostname or IP address

$cfg ['Servers'] [$I] [' host'] = '172.16.0.35 alternative / this item may not be modified.

After modification, the entry of "server" will be added when you log in to phpMySQL again. Enter the IP of the MySQL server here (note: it is the IP address where the http server accesses the MySQL):

3. Prompt "configuration file now needs a phrase password" after logging in:

Solution:

Modify phpMyAdmin/config.inc.php:

$cfg ['blowfish_secret'] =' oimec';// the oimec here is an arbitrary phrase and is used as the key of the AES encryption algorithm for cookie authentication

4. After logging in, prompt "phpMyAdmin advanced features have not been set up, some functions are activated." :

Solution:

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

Log in to phpMyAdmin again, check that there is no prompt, and that the "phpmyadmin" database has been created.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.