phpMyAdmin installation Settings

phpMyAdmin is a MySQL management tool that manages MySQL directly from the web.   Assuming your web (web hosting) root directory is/var/www/assume that your host Web Access is such http://192.168.1.11/you can install him to/var/www/phpmyadmin of course, but/var/www/'s arbitrary sub-directory Attention

phpMyAdmin is a MySQL management tool that manages MySQL directly from the web.

Assuming your web (web hosting) root directory is/var/www/assume that your host Web Access is such http://192.168.1.11/

You can install him into/var/www/phpmyadmin, of course, but/var/www/'s arbitrary sub-directory.

Note that this directory name is best known only by the administrator. So we're assuming/var/www/onlyyouknow.

A. Go to phpMyAdmin's official station to download the latest phpMyAdmin program

Http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

Download the phpmyadmin-2.11.3-all-languages.tar.bz2 to/var/www/

#cd/var/www/

#wget http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

Of course, you can also go to your own Windows machine, and then edit it later to upload to the Web server

B. Unzip this file

# tar ZXVF phpmyadmin-2.11.3-all-languages.tar.gz

This is the path/var/www/phpmyadmin-2.11.3-all-languages

C. Modify the directory named/var/www/onlyyoukown

# Mv/var/www/phpmyadmin-2.11.3-all-languages/var/www/onlyyoukown

D. Modify the settings file

1. Locate the/libraries/config.default.php file (config.default.php copied to the phpMyAdmin directory and rename it to config.inc.php), which has the following items (2-8) to be configured on its own , Windows uses WordPad (do not use Notepad, which is UTF8 encoding) for editing, directly under Linux with Vim.

2. Find $cfg [' Pmaabsoluteuri '] to modify the URL of the phpmyadmin you will upload to the space

such as: $cfg [' pmaabsoluteuri '] = ' http://192.168.1.11/onlyyouknow/';

3. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; (usually with default, with exception, without modification)

4. Find $cfg [' Servers '] [$i] [' auth_type '] = ' config ';

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.

5. Find $cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user (MySQL username, root in his machine)

6. Find $cfg [' Servers '] [$i] [' password '] = '; MySQL password (mysql user's password, their server is generally the password of the MySQL user root)

7. Find $cfg [' Servers '] [$i] [' only_db '] = '; If set to a db-name, only (you have only one data set up; If you're on this computer or want to build a server, leave the suggestion blank)

8. Find $cfg [' defaultlang '] = ' zh '; (Here is the choice of language, zh for Simplified Chinese meaning, here do not know to fill GBK to No)

9. Save when Setup is complete

If "configuration file now requires top secret phrase password (blowfish_secret)" then please set your website's cookie in $cfg[' blowfish_secret ' = ';, for example: $cfg [' Blowfish_ Secret '] = ' any character '; This is because of your "$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '.

E. Testing

Open Browser, http://192.168.1.11/onlyyoukown/

A little personal opinion

We think it is not a very safe way to control MySQL from the root user of MySQL on the web. So my advice is that if you run out of servers, you can put the Phpadmin directory into a directory that the Web cannot access. Move the entire directory back to its original location with the MV command when it's time to use

///////////////////////////////////////////////////////////////////////////////////////////////////

Open phpMyAdmin, log in, the following problems occur, prompted:#1045 Unable to log on to the MySQL Server

The following error condition may occur: phpMyAdmin:#1045 cannot log on to the MySQL server . Access denied for user ' root ' @ ' localhost ' (using Password:yes)

problem Reason: this may be because the previous setup MySQL password did not succeed, so we use the set Mysqlroot password cannot log on to the server.

Workaround: You can then attempt to log into the database using the empty password of the MySQL default root account.

If you log in with a blank password, it appears: empty password login is forbidden ( see allow null password ) error. To modify the/phpmyadmin/libraries/config.default.php and/phpmyadmi/config.inc.php two files, locate the following two lines

$cfg [' Servers '] [$i] [' Nopassword ']= false;
$cfg [' Servers '] [$i] [' allownopassword '] = false;

Change two false to True and set $cfg [' Servers '] [$i] [' Password ']= '; phpMyAdmin will allow you to log in to the MySQL database with a blank password after setting up the configuration file.

phpMyAdmin installation Settings