Home >Backend Development >PHP Tutorial >Illustrated tutorial on Phpmyadmin installation and configuration method_PHP tutorial
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.phpThe 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';
Here I assign the value to leapsoul.cn, this password is used to encrypt Cookies
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 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 Previous article:Two PHP database backup program codes_PHP tutorialNext article:Two PHP database backup program codes_PHP tutorial Related articlesSee more |