Installation and use of phpMyAdmin

Source: Internet
Author: User
Tags php and mysql

First download the corresponding phpMyAdmin version in the phpMyAdmin's official website based on your PHP and MySQL version.

The Red box section of the figure identifies the PHP version and the MYADL version of this version of the support amount.

For example, this version is supported for PHP5.3 and MYSQL5.5 versions. Get PHP and MySQL version see http://www.cnblogs.com/yiluxiuxing/p/4307296.html (Get PHP configuration information)

Download the phpMyAdmin folder and upload it directly to the Web site root directory.

Open the phpmyadmin/libraries/config.default.php file for editing.

Find the following variables and edit

$cfg [' pmaabsoluteuri '] = ' http://www.simple.com/phpmyadmin ';//fill in phpMyAdmin's access URL here

$cfg [' Servers '] [$i] [' host '] = ' localhost '; Fill in the IP address of localhost or MySQL server, and if MySQL and the phpMyAdmin are on the same server, press the default localhost

$cfg [' Servers '] [$i] [' port '] = '; MySQL port, if it is the default 3306, leave it blank

$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user access phpmyadmin using the MySQL username

fg[' Servers ' [$i] [' password '] = '; MySQL password (only needed password corresponding to the above MySQL username

$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';

There are four different modes to choose from, Cookie,http,http,config

The Config method is to enter the phpMyAdmin access URL directly, no need to enter the user name and password, is not safe, is not recommended to use.
When the entry is set to Cookie,http or HTTP, the login phpMyAdmin requires a data user name and password for authentication, as follows:
PHP installation mode is Apache, you can use HTTP and cookies;
PHP installation mode is CGI, you can use cookies

After the configuration is complete, if the browser enters http://www.simple.com/phpmyadmin to log in

If the display fails to log on to the server

Will $cfg[' Servers ' [$i] [' host '] = ' localhost ';

Instead of $cfg[' Servers ' [$i] [' host '] = ' 127.0.0.1 ';

Installation and use of phpMyAdmin

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.