phpMyAdmin Simple Installation Tutorial

Source: Internet
Author: User
Tags config mysql mysql host php file mysql database phpmyadmin

phpMyAdmin is a MySQL database management tool, after the installation of the tool, that is, the Web form can directly manage the MySQL data, without the need to execute system commands to manage, is very suitable for database operation commands unfamiliar database managers, the following detailed description of the tool installation method.

Download Address: phpMyAdmin

First, download

phpMyAdmin software Station to download the first, you can also go to the phpMyAdmin official website download, and then extract to the Web can access the directory, if it is virtual space, you can extract the FTP tool uploaded to the Web directory, at the same time you can modify the name of the file after decompression.

Second, the configuration

Open the Libraries directory of the config.default.php file, in turn, find the following items, according to the instructions configured.

1. Visit the website

$cfg ["Pmaabsoluteuri"] = ""; Fill out phpMyAdmin's visit URL here.

2, MySQL host information

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

Fill in the IP address of the localhost or MySQL server, if MySQL and the phpMyAdmin are on the same server, press default localhost

$cfg ["Servers"] [$i] ["port"] = ""; MySQL Port-leave blank for default port

MySQL port, the default is 3306, leave blank, if you install MySQL using the other port, you need to fill in here.

3, MySQL username and password

$cfg ["Servers"] [$i] ["user"] = "root"; Fill in the MySQL username used by MySQL access phpMyAdmin, default to root.

fg["Servers" [$i] ["password"] = ""; Fill in the password corresponding to the MySQL username above.

4. Authentication method

$cfg ["Servers"] [$i] ["auth_type"] = "cookie"; for security reasons, it is recommended to fill in cookies here.

Here are four modes to choose from, Cookie,http,http,config

Config mode is to enter the phpMyAdmin access URL can be directly entered, without entering a username and password, is not safe, do not recommend use.

When the entry is set to Cookie,http or HTTP, the login phpMyAdmin requires a data username and password to authenticate, as follows:

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

The PHP installation mode is CGI and you can use cookies.

5, phrase password (blowfish_secret) settings

$cfg ["blowfish_secret"] = ""; If the authentication method is set to a cookie, you need to set the phrase password, set why the password, it is up to you to decide, you can not leave this blank, otherwise you will be prompted when the login phpMyAdmin error.

Once the installation is complete, we can access it in the browser, as shown in the following illustration:




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.