Setting of the phrase password (blowfish_secret)

Source: Internet
Author: User
Tags mysql host

Simply put, phpMyAdmin is a MySQL management tool, after installing the tool, you can directly manage the MySQL data through the web, without the need to execute system commands to manage, is very suitable for database Operations Command unfamiliar Database manager, Here's how to install the tool:

1. First go to the Internet to download phpMyAdmin, and then extract to the Web directory can be accessed (if it is virtual space, can be extracted via FTP and other uploads to the web directory), of course, you can modify the name of the file after decompression.

2. Configure config file
Open the config.default.php file under libraries, locate the following, and then follow the instructions to configure it:
A. Access to the Web site
B.mysql Host Information
C.mysql User name and password

$cfg [' Servers '] [$i] [' user '] = ' root ';//MySQL User access the MySQL user name used by phpMyAdmin
fg[' Servers ' [$i] [' password '] = '; MySQL password (only needed password corresponding to the above MySQL username

D. Authentication methods

$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 cookie2881064151

E. Setting of the phrase password (blowfish_secret)

$cfg [' blowfish_secret '] = ';

If the authentication method is set to a cookie, you will need to set the phrase password, put in the setting why the password, it is up to you to decide, but can not be left blank, or you may be prompted with error when logging in phpMyAdmin
OK, so far, you have successfully installed the phpMyAdmin, simple, quickly login experience it

$cfg [' pmaabsoluteuri '] = '; Fill in phpMyAdmin's access URL here

$cfg [' Servers '] [$i] [' host '] = ' localhost ';//MySQL hostname or IP address
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-leave blank for default port
MySQL port, if it is the default 3306, leave it blank

Setting of the phrase password (blowfish_secret)

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.