Phpmyadmin installation tutorial phpmyadmin installation Configuration

Source: Internet
Author: User
Tags mysql host

Phpmyadmin installation tutorial phpmyadmin installation Configuration

How to install phpmyadmin? Some friends may not know how to install phpmyadmin. The following green tea editor will detail the phpmyadmin installation and configuration tutorial. If you need it, please refer to it!

Phpmyadmin is a mysql management tool. After installing this tool, you can directly manage mysql Data in the form of web, instead of executing system commands, it is very suitable for database managers who are unfamiliar with database operation commands.

PHPMyAdmin installation Configuration:

1. The PHPMyAdmin package downloaded from the internet is usually released to the htdocs directory, for example, htdocs \ phpmyadmin.

2. Open the phpmyadmin directory and check whether the config. sample. inc. php file exists. If so, rename it config. inc. php. (Depending on the version, config may be directly available. inc. PHP file, you do not need to change the name, or there may be no config. sample. inc. php or config. inc. php, go to the phpmyadmin \ libraries directory and set config. default. copy php to the phpmyadmin directory and rename it config. inc. php ).

3. open config. inc. in the PHP file (you can use the WordPad), find $ cfg ['blowfish _ secret'] = ''; and $ cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';, if the value of $ cfg ['servers'] [$ I] ['auth _ type'] is as cookie as we saw earlier, therefore, we must write a string of characters in the quotation marks of $ cfg ['blowfish _ secret'] = ''. You can regard it as an identity verification code. For example, $ cfg ['blowfish _ secret'] = 'sunec '. Save the disk and exit.

So far, the installation and configuration of phpmyadmin is over. Enter the browser and enter http: // localhost/phpmyadmin/main in the address bar. php, (the path here is determined based on the name of the directory where you previously decompressed phpmyadmin to htdocs). If it succeeds, the page displays a picture asking you to enter your username and password, enter the username and password (Mysql username and password) and enter the main interface of phpmyadmin. As for usage ~ We will not start it here for the time being. You can explore it first ~

How to install the tool:

1. download phpmyadmin from the Internet and decompress it to the accessible web directory (if it is a virtual space, decompress it and upload it to the web directory through ftp ), of course, you can modify the name of the extracted file.

2. Configure the config file

Open the config. default. php file under libraries, find the following items in sequence, and configure the items as instructed:

A. Visit the website

$ Cfg ['pmaabsoluteuri '] = ''; enter the phpmyadmin access URL here.

B. mysql host information

$ Cfg ['servers'] [$ I] ['host'] = 'localhost'; // MySQL hostname or IP address

Enter the IP address of the localhost or mysql server. If mysql and 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 3306 by default, leave it blank.

C. mysql user name and password

$ Cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user used by phpmyadmin to access the mysql user name

Fg ['servers'] [$ I] ['Password'] = ''; // MySQL password (only needed corresponds to the password of the above mysql user name

D. Authentication Method

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';

There are four modes available here: cookie, http, HTTP, config

In config mode, you can directly access the phpmyadmin access URL without entering the user name and password. It is insecure and is not recommended.

When this option is set to cookie, http, or HTTP, You need to verify the data username and password to log on to phpmyadmin. The details are as follows:

The PHP installation mode is Apache, and http and cookie can be used;

The PHP installation mode is CGI and cookie can be used.

E. Set the phrase password (blowfish_secret)

$ Cfg ['blowfish _ secret'] = '';

If the authentication method is set to cookie, you need to set the phrase password and the Setting Password, which is determined by yourself, but cannot be left blank. Otherwise, an error will be prompted when you log on to phpmyadmin.

So far, you have successfully installed phpmyadmin. Easy to use. log on to the console and try again.

Configuration

3. Open/libraries/config. default. PHP file (the old version is config in the root directory. inc. PHP file), use a WordPad (do not use Notepad, this is UTF8 encoding) for editing, follow the instructions to configure.

4. Find $ cfg ['pmaabsoluteuri '] = ''; // modify the phpMyAdmin URL of the space to be uploaded.

For example, $ cfg ['pmaabsoluteuri '] = 'HTTP: // website domain name/phpmyadmin /';

5. Search for $ cfg ['servers'] [$ I] ['host'] = 'localhost'; // The default value is usually used, and there are exceptions. You do not need to modify the value.

6. find $ cfg ['servers'] [$ I] ['auth _ type'] = 'config'; // debug config in your own machine; if a cookie is used for the space on the network.

There are four modes available: cookie, http, HTTP, config

① You can directly enter the phpMyAdmin access URL in config mode without entering the user name and password. It is insecure and is not recommended.

② Set the cookie, http, and HTTP methods. to log on to phpMyAdmin, you need the data username and password for verification.

Specifically, the PHP installation mode is Apache, and http and cookie can be used. The PHP installation mode is CGI and cookie can be used.

7. Search for $ cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL Username

8. find $ cfg ['servers'] [$ I] ['Password'] = ''; // MySQL password (only leave the needed blank)

9. find $ cfg ['servers'] [$ I] ['only _ db'] = ''; // you can set only one data, set your database name. If you want to set up a server, leave it blank.

10. find $ cfg ['defaultlang '] = 'zh'; // select a language. zh indicates the meaning of Simplified Chinese.

 

11. find $ cfg ['blowfish _ secret'] = ''; // If the authentication method is set to cookie, you need to set the phrase password and the reason for setting the password, leave it blank. Otherwise, an error will be prompted when you log on to phpMyAdmin.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.