Configuration of the phpMyAdmin

Long time no writing, come up and record a little something you learned today ~

Before the PHP development, has been using SQLyog to operate the MySQL database, but today found that SQLyog function is not very perfect, mainly I want to modify the database name, but SQLyog do not support, that there is no way, can only change the way to go. Say dry, find some information on the Internet, found that phpMyAdmin can, so immediately download a phpmyadmin, do not need to install, directly decompression compression package can be, the next is the configuration of the matter.

Because I have been using the XAMPP integration package, so there is no doubt that the entire extracted folder first dropped to the. /xampp/htdocs folder inside, and then find the phpMyAdmin inside the Libraries folder below the config.default.php file, which is we need to modify the configuration file.

1. Modify the Access URL: $cfg [' pmaabsoluteuri '] = '; Fill in the PhpMyAdmin's access URL, as mine is $cfg[' pmaabsoluteuri '] = ' http://localhost/phpMyAdmin/';

2. Modify the MySQL host information: $cfg [' Servers '] [$i] [' host '] = ' localhost '; If MySQL and phpMyAdmin are on the same server, simply fill in localhost, otherwise fill in the IP address of the server where MySQL resides

$cfg [' Servers '] [$i] [' port '] = '; MySQL port number, if you are using the default port 3306, leave a space

3. Modify the MySQL username and password: $cfg [' Servers '] [$i] [' user '] = ' root '; User access to the MySQL user name used by phpMyAdmin
$cfg [' Servers '] [$i] [' password '] = '; Password for the above user name

4. Modify the authentication method: $cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; There are four modes to choose from, Cookie,http,http,config. The Config method is to enter the phpMyAdmin access URL directly, no need to enter the user name and password, is not safe, is not recommended to use. When the key is set to Cookie,http or HTTP, the login phpMyAdmin requires a data user name and password for authentication.

5. Set phrase password: $cfg [' blowfish_secret '] = '; If the authentication method is set to a cookie, you will need to set the phrase password to set why the password is up to you, but you can't leave it blank, or you'll be prompted with an error when you log in to phpMyAdmin.

Well, to here on the configuration is complete, and then as long as the login phpMyAdmin can, but also remember their landing URL, directly enter the URL to jump to the login interface, enter the account password on the line, strange, hint I can not enter a blank password, because my original root account without password, But what if he doesn't let you enter a blank password? Don't worry, let's take a closer look at the configuration file, or config.default.php this file, $cfg [' Servers '] [$i] [' nopassword '] = false; $cfg [' Servers '] [$i] [' allownopassword '] = false; Find these two lines of code, and then change the false to true can be, the meaning of the name should be understood, we try to login once again, OK, landing successful, done, At this point our phpMyAdmin configuration is complete, the rest is going to explore the function inside.

Here's a brief introduction to the ability to modify the root account password:

1. After logging in to phpMyAdmin, locate the MySQL database on the left and click Enter

2. Click on the SQL above, enter the code in the statement input box: Update user set Password=password (' 123456 ') where user= ' root ', where 123,456 bits you want to change the password

3. Click Execute in the lower right corner and then go to config.default.php file to modify $cfg[' Servers ' [$i] [' password '] = ';

4. Restart MySQL on the server, so that the password of your root account has been modified successfully, is not very convenient?

This article is purely a novice post, God automatically ignore, non-happy Spray ~

Configuration of the phpMyAdmin