phpMyAdmin installation Configuration method Illustrated Tutorial _php Tutorial

Source: Internet
Author: User
Tags php mysql web database
phpMyAdmin is now the majority of PHP MySQL developers use a Web database management tool, phpMyAdmin installation configuration method is very simple, let me introduce you to the phpMyAdmin installation configuration method diagram, there is a need to know the friend can refer to.

Analysis

Locate the/libraries/config.default.php file (the old version is the config.inc.php file under the root directory), and use WordPad (do not use Notepad, which is UTF8 encoding) for editing.
4, find $cfg [' Pmaabsoluteuri ']
Modify the URL of the phpmyadmin you will upload to the space
such as: $cfg [' pmaabsoluteuri '] = ' http://www.xxx.com/ Phpmyadmin/';
5, find $cfg [' Servers '] [$i] [' host '] = ' localhost ', (usually with default, with exceptions, can not be modified)
6, find $cfg [' Servers '] [$i] [' auth_type '] = ' Config ';
Debug with config in its own machine, if the space on the network with a cookie, where we have already added the URL in front of the change to a cookie, it is recommended to use cookies.
7, find $cfg [' Servers '] [$i] [' user '] = ' root ';//MySQL User (username, usually here just fill in a few letters on it; In special cases, use root in your own machine, on the Internet generally for your FTP user name, The virtual hosting provider tells you, generally do not modify.)
8, find $cfg [' Servers '] [$i] [' password '] = "; MySQL password (only needed left blank)
9, find $cfg [' Servers '] [$i] [' only_db '] = "; If set to a db-name, only (you have only one data set up, set as your database name; If you want to build a server, then leave the suggestion blank)
10, find $cfg [' defaultlang '] = ' zh '; (this is the language of choice, Zh for Simplified Chinese meaning)
11, find $cfg[' Blowfish_secret '], please set your website's cookie in $cfg[' blowfish_secret ' = '; A cookie is a domain name that accesses phpMyAdmin, for example: $cfg [' blowfish_secret '] = ' www.xinnethz.net ';.


phpMyAdmin the additional features of the linked table have not been activated how is the problem resolved?

Back to what we saw although the phpMyAdmin configuration is ready to use, but the bottom is still prompting some configuration work is not complete, one hint: the additional features of the linked table has not been activated, then how to solve it?

First, click the Import link, upload scripts/create_tables.sql and execute to create the phpMyAdmin database.

Second, found in the phpMyAdmin configuration file config.default.php

code 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 ';
?

These variables are empty by default in the phpMyAdmin configuration file, and you only need to assign a value to the variable based on the comment.

After completing the above configuration operation, close the browser and log in again.

phpMyAdmin configuration file now requires a phrase password how to solve?

Found in phpMyAdmin configuration file config.default.php

The code is as follows Copy Code

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

Here I am assigned a value of leapsoul.cn, this password is used for the encryption of cookies


phpMyAdmin Login Method Description

In Phpmyadmin3, there are a total of four ways to sign in

Config: Enter the phpMyAdmin telnet address directly, as long as the user name password is set in the configuration file.

http: Pop-up dialog box, enter user name and password

Signon: Similar to the page Jump login method, also need to set $cfg[' Servers ' [$i] [' Signonurl '], when you enter the phpMyAdmin remote login address will automatically jump to Signonurl set URL.

Cookies: This is the way to log in when phpMyAdmin is configured.

Now that the entire phpmyadmin3 installation and configuration work is complete, you can experience the new features of the phpMyAdmin new version.

http://www.bkjia.com/PHPjc/630710.html www.bkjia.com true http://www.bkjia.com/PHPjc/630710.html techarticle phpMyAdmin is now the majority of PHP MySQL developers use a Web database management tool, phpMyAdmin installation configuration method is very simple, let me introduce you to phpMyAdmin Ann ...

  • 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.