Home >Backend Development >PHP Tutorial >Illustrated tutorial on Phpmyadmin installation and configuration method_PHP tutorial

Illustrated tutorial on Phpmyadmin installation and configuration method_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 17:06:14885browse

Phpmyadmin is a WEB database management tool used by most PHP mysql developers now. The installation and configuration method of Phpmyadmin is also very simple. Below I will introduce you to the diagram of the Phpmyadmin installation and configuration method. Friends who need to know more can refer to it. .

Analysis

Find the /libraries/config.default.php file (the old version is the config.inc.php file in the root directory) and edit it with WordPad (do not use Notepad, this is UTF8 encoding).
4. Find $cfg['PmaAbsoluteUri']
Change it to the URL of phpMyAdmin that you will upload to the space
For example: $cfg['PmaAbsoluteUri'] = ‘http://www.xxx.com/phpmyadmin/’;
5. Find $cfg['Servers'][$i]['host'] = 'localhost'; (usually the default is used, there are exceptions, and no modification is required)
6. Find $cfg['Servers'][$i]['auth_type'] = ‘config’;
Use config for debugging on your own machine; if you use cookies in the Internet space, since we have added the URL before, we will change it to cookies. It is recommended to use cookies here.
7. Search for $cfg['Servers'][$i]['user'] = 'root'; // MySQL user (user name, usually just fill in a few letters here; in special cases, you can enter it in your own machine Use root, which is usually your ftp username on the Internet. The virtual host provider will tell you, generally do not change it.)
8. Find $cfg['Servers'][$i]['password'] = ”; // MySQL password (only needed, just leave it blank)
9. Find $cfg['Servers'][$i]['only_db'] = ”; // If set to a db-name, only (If you only have one data, set it to your database name; if If you want to set up a server, it is recommended to leave it blank)
10. Search $cfg['DefaultLang'] = ‘zh’; (Here is the language selection, zh means Simplified Chinese)
11. To find $cfg['blowfish_secret'], please set the cookie of your website in the equal sign of $cfg['blowfish_secret'] = ' '; (the cookie is the domain name used to access phpmyadmin), for example: $cfg['blowfish_secret '] = 'www.xinnethz.net';.


How to solve the problem that the additional features of phpmyadmin's linked table have not been activated?

Going back to the picture above, we see that although the phpmyadmin configuration is complete and can be used, there is still a prompt at the bottom that some configuration work has not been completed. One of the prompts: The additional features of the linked table have not been activated, so how to solve it?

First, click the import link, upload scripts/create_tables.sql and execute it to create the phpmyadmin database.

Secondly, find

in the phpmyadmin configuration file config.default.php
The code is as follows Copy code
 代码如下 复制代码

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';

$cfg['Servers'][$i]['relation'] = 'pma_relation';

$cfg['Servers'][$i]['table_info'] = 'pma_table_info';

$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';

$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';

$cfg['Servers'][$i]['column_info'] = 'pma_column_info';

$cfg['Servers'][$i]['history'] = 'pma_history';

$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
?>

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';

$cfg['Servers'][$i]['relation'] = 'pma_relation';

$cfg['Servers'][$i]['table_info'] = 'pma_table_info';

代码如下 复制代码

$cfg['blowfish_secret'] = 'leapsoul.cn'
?>

$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; $cfg['Servers'][$i]['history'] = 'pma_history'; $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; $cfg['Servers'][$i]['tracking'] = 'pma_tracking'; ?> In the phpmyadmin configuration file, these variables are empty by default. You only need to assign values ​​to the variables according to the comments. After completing the above configuration operations, close the browser and log in again. How to solve the problem that the phpmyadmin configuration file now requires a phrase password? Find in the phpmyadmin configuration file config.default.php
The code is as follows Copy code
$cfg['blowfish_secret'] = 'leapsoul.cn'<🎜> ?>

Here I assign the value to leapsoul.cn, this password is used to encrypt Cookies


phpmyadmin login method instructions

In phpmyadmin3, there are a total of four login methods

Config: Just enter the phpmyadmin remote login address directly. Just set the username and password in the configuration file.

http: A dialog box will pop up, enter your username and password and enter

Signon: A login method similar to page jump. At the same time, $cfg['Servers'][$i]['SignonURL'] needs to be set. When you enter the remote login address of phpmyadmin, it will automatically jump to signonURL. URL set.

Cookie: This is the login method when phpmyadmin is configured.

At this point, the entire installation and configuration of phpmyadmin3 is completed. You can experience the new features of the new version of phpmyadmin

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630710.htmlTechArticlePhpmyadmin is a WEB database management tool used by most php mysql developers now. The installation and configuration method of Phpmyadmin is also the same. It’s very simple. Let me introduce Phpmyadmin to you...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn