phpMyAdmin Installation Tutorial phpMyAdmin installation configuration _php Tutorial

phpMyAdmin Installation Tutorial phpMyAdmin installation configuration

phpMyAdmin How to install? Some friends may not know how to install phpMyAdmin, below the green Tea Small series for everyone to introduce the next phpMyAdmin installation configuration tutorial, have the need for friends hurriedly refer to the next bar!

phpMyAdmin is a MySQL management tool that, after installing the tool, can directly manage MySQL data in web form without the need to execute system commands, which is ideal for database administrators who are unfamiliar with database operations commands.

phpMyAdmin Installation configuration:

1. The phpMyAdmin downloaded to the general Web is a compressed package that we release into the Htdocs directory, such as Htdocs\phpmyadmin.

2. Open the phpMyAdmin directory, if there is a config.sample.inc.php file in this directory, and if so, rename it to config.inc.php. (depending on the version, it is possible to have the config.inc.php file directly, it does not need to rename, there may be no config.sample.inc.php or config.inc.php, then we will go to phpmyadmin\ Under the Libraries directory, copy the config.default.php to the phpMyAdmin directory and rename it to config.inc.php).

3. Open the config.inc.php file (can use WordPad), find $cfg[' Blowfish_secret ']= ', and $cfg[' Servers ' [$i] [' auth_type ']= ' cookie '; if $cfg[' The value of Servers ' [$i] [' Auth_type '] is a cookie as seen earlier, so we must write a string of characters in the quotation marks of $cfg[' Blowfish_secret ']= ', which you can interpret as an authentication code. such as $cfg[' Blowfish_secret ']= ' Sunec '. Save to exit.

At this point, phpmyadmin installation configuration work is finished, enter the browser, in the address bar input http://localhost/phpmyadmin/main.php, ( Here the path is based on the previous you will phpmyadmin decompression in the directory name of Htdocs, the smooth words, the page should appear let you enter the user name password screen, enter the user name password (mysql username password), and then into the main interface phpMyAdmin. As for the use of the method ~ is not here to expand, you can first find out for yourself ~

How to install the tool:

1. First go to the Internet to download phpMyAdmin, and then extract to the Web directory can be accessed (if it is virtual space, can be extracted via FTP and other uploads to the web directory), of course, you can modify the name of the file after decompression.

2. Configure config file

Open the config.default.php file under libraries, locate the following, and then follow the instructions to configure it:

A. Access to the Web site

$cfg [' pmaabsoluteuri '] = '; Fill in phpMyAdmin's access URL here

B.mysql Host Information

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

Fill in the IP address of localhost or MySQL server, and if MySQL and the phpMyAdmin are on the same server, press the default localhost

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

MySQL port, if it is the default 3306, leave it blank

C.mysql User name and password

$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user access phpmyadmin using the MySQL username

fg[' Servers ' [$i] [' password '] = '; MySQL password (only needed password corresponding to the above MySQL username

D. Authentication methods

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

There are four different 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 entry is set to Cookie,http or HTTP, the login phpMyAdmin requires a data user name and password for authentication, as follows:

PHP installation mode is Apache, you can use HTTP and cookies;

PHP installation mode is CGI, you can use cookies

E. Setting of the phrase password (blowfish_secret)

$cfg [' blowfish_secret '] = ';

If the authentication method is set to a cookie, you will need to set the phrase password, put in the setting why the password, it is up to you to decide, but can not be left blank, or you may be prompted with error when logging in phpMyAdmin

OK, so far, you have successfully installed the phpMyAdmin, simple:), quickly login experience.

Configuration

3, open the/libraries/config.default.php file (the old version is the root directory of the config.inc.php file), with WordPad (do not use Notepad, which is UTF8 encoding) for editing, follow the instructions to configure.

4, find $cfg [' Pmaabsoluteuri ']= '; Modify the URL of the phpmyadmin that you will upload to the space

such as: $cfg [' pmaabsoluteuri '] = ' http://website domain name/phpmyadmin/';

5. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; Usually with the default, there are exceptions, you can not modify

6, find $cfg [' Servers '] [$i] [' auth_type '] = ' config '; Debug in your own machine with config, if the space on the network with a cookie.

Here are four modes to choose from: Cookie,http,http,config

①config mode is to enter the phpMyAdmin access URL directly to enter, no need to enter the user name and password, is not safe, is not recommended to use.

② set cookie,http,http mode, login phpMyAdmin require data user name and password to authenticate.

The following: PHP installation mode for Apache, you can use HTTP and cookies; PHP installation mode is CGI, you can use cookies.

7. Find $cfg [' Servers '] [$i] [' user '] = ' root '; MySQL User name

8. Find $cfg [' Servers '] [$i] [' password '] = '; MySQL password (only needed left blank)

9. Find $cfg [' Servers '] [$i] [' only_db '] = '; You only have one data set up, set as your database name, if you want to build a server, then suggest leave blank

10, find $cfg [' defaultlang '] = ' zh '; Here is the language of choice, en stands for Simplified Chinese meaning

11, find $cfg[' blowfish_secret '] = "; If the authentication method is set to a cookie, you need to set the phrase password, set why the password, by your own discretion, this can not be left blank, otherwise you will be prompted to log phpmyadmin error.

http://www.bkjia.com/PHPjc/919976.html www.bkjia.com true http://www.bkjia.com/PHPjc/919976.html techarticle phpMyAdmin Installation Tutorial phpMyAdmin installation configuration phpMyAdmin How do I install it? Some friends may not know how to install the phpMyAdmin, below the green Tea Small series for everyone to introduce the next phpMyAdmin ann ...

