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 introduce the phpmyadmin installation and configuration tutorial in detail. Friends in need can quickly refer to it!

phpmyadmin is a mysql management tool. After installing this tool, you can directly manage mysql data through the web without the need to execute system commands. It is very suitable for database managers who are not familiar with database operation commands.

PHPMyAdmin installation configuration:

1. Generally, the PHPMyAdmin downloaded from the Internet is a compressed package. We release it into the htdocs directory, such as htdocsphpmyadmin.

2. Open the phpmyadmin directory and check if there is a config.sample.inc.php file in this directory. If it exists, rename it to config.inc.php. (Depending on the version, there may be a config.inc.php file directly, so there is no need to change the name. There may also be no config.sample.inc.php or config.inc.php at all. Then we will go to the phpmyadminlibraries directory and change the config. .default.php is copied to the phpmyadmin directory and renamed config.inc.php).

3. Open the config.inc.php file (you can use WordPad) and find $cfg['blowfish_secret']=''; and $cfg['Servers'][$i]['auth_type']=' cookie';, if the value of $cfg['Servers'][$i]['auth_type'] is cookie as seen earlier, then we must put quotes in $cfg['blowfish_secret']='' Write any string of characters into it, and you can understand it as an identity verification code. For example $cfg['blowfish_secret']='sunec'. Save and exit.

At this point, the installation and configuration of phpmyadmin is over. Enter the browser and enter http://localhost/phpmyadmin/main.php in the address bar. (The path here is based on the directory name where you unzipped phpmyadmin in htdocs. Determined), if everything goes well, a screen for you to enter your username and password should appear on the page. Enter your username and password (Mysql username and password), and then enter the main interface of phpmyadmin. As for how to use it, I won’t go into it here for the time being. You can explore it yourself first~

How to install this tool:

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

　2. Configure config file

Open the config.default.php file under libraries, find the following items in order, and configure them according to the instructions:

A. Visit the website

　$cfg['PmaAbsoluteUri'] = '';Fill in the access URL of phpmyadmin here

B.mysql host information

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

Fill in the IP address of localhost or the server where mysql is located. 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, just leave it empty

　C.mysql username and password

　$cfg['Servers'][$i]['user'] = 'root'; // MySQL username used by MySQL user to access phpmyadmin

　fg['Servers'][$i]['password'] = ''; // MySQL password (only neededThe password corresponding to the above mysql user name

D. 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 access URL of phpmyadmin to enter directly without entering the user name and password. It is unsafe and not recommended.

When this item is set to cookie, http or HTTP, logging in to phpmyadmin requires a data username and password for verification, as follows:

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

PHP installation mode is CGI, cookies can be used

E. Phrase password (blowfish_secret) settings

$cfg['blowfish_secret'] = '';

If the authentication method is set to cookie, you need to set a phrase password. It is up to you to decide what password to set, but it cannot be left blank, otherwise an error will be prompted when logging in to phpmyadmin

Okay, so far, you have successfully installed phpmyadmin, it’s easy :), log in to experience it.

Configuration

3. Open the /libraries/config.default.php file (the old version is the config.inc.php file in the root directory), edit it with WordPad (do not use Notepad, this is UTF8 encoding), and follow the instructions Just configure it.

4. Find $cfg['PmaAbsoluteUri']=''; // Change it to the URL of phpMyAdmin that you will upload to the space

For example: $cfg['PmaAbsoluteUri'] ='http: // Website domain name/phpmyadmin/';

5. Search $cfg['Servers'][$i]['host'] ='localhost'; // Usually the default is used, there are exceptions, no need to modify it

6. Find $cfg['Servers'][$i]['auth_type'] ='config'; // Use config for debugging on your own machine; if you are on the network, use cookies.

There are four modes to choose from: cookie, http, HTTP, config

?、?The config method is to enter the access URL of phpMyAdmin to enter directly without entering the user name and password. It is unsafe and not recommended.

?、?Set cookie, http, HTTP method, log in to phpMyAdmin and need data user name and password for verification.

The details are as follows: PHP installation mode is Apache, you can use http and cookies; PHP installation mode is CGI, you can use cookies.

7. Search $cfg['Servers'][$i]['user'] = 'root'; // MySQL user name

8. Search $cfg['Servers'][$i]['password'] =''; // MySQL password (only needed, just leave it blank)

9. Find $cfg['Servers'][$i]['only_db'] = ''; // If you only have one data, set it to your database name; if you want to set up a server, then It is recommended to leave it blank

10. Search $cfg['DefaultLang'] = 'zh'; // Here is the language selection, zh represents Simplified Chinese

11. Find $cfg['blowfish_secret'] =''; // If the authentication method is set to cookie, you need to set a phrase password. It is up to you to decide what password to set. You cannot leave it blank here, otherwise it will fail when logging in. An error will be prompted when using phpMyAdmin.