phpMyAdmin configuration method and installation Tutorial _php tutorial

Source: Internet
Author: User
Tags mysql host
Today, let's see. phpMyAdmin Configuration Tutorial, it can also be called phpMyAdmin Installation, install I will not say, you directly to the Internet to download a phpMyAdminUnpack the package to your site directory. Let's look at a simple example.

Installation directory:/admin/

All right, let's open the folder we just unzipped, find config.sample.inc.php and rename it to config.inc.php. We'll open this file.

Found it

$cfg [' pmaabsoluteuri '] = ';
$cfg [' eexectimelimit '] =;

We set $cfg[' Pamabsolteuri] to your directory my/admin/directory, $cfg [' Eexectimelimit '] I set to 10000

$cfg [' pmaabsoluteuri '] = '/admin/';
$cfg [' eexectimelimit '] = 10000;

Then find $cfg[' blowfish_secret '] = ';

$cfg [' blowfish_secret '] = ' cookie ';

Find $cfg[' Servers ' [$i] [' host '] = '//MySQL hostname or IP address

Here is the setting to connect the MySQL host, can be the host can also be an IP address.

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

We'll find it below.

$cfg [' Servers '] [$i] [' auth_type '] = '; Authentication method (valid Choices:config, HTTP, HTTP, signon or cookie)
$cfg [' Servers '] [$i] [' user '] = '; MySQL User
$cfg [' Servers '] [$i] [' password '] = ';

The above three kinds of what meaning I will not say a lot of you look at my configuration.

$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; Authentication method (valid Choices:config, HTTP, HTTP, signon or cookie)
$cfg [' Servers '] [$i] [' user '] = ' p123456 '; Your MySQL user
$cfg [' Servers '] [$i] [' password '] = ' ****** '; Here's your MySQL password.

Okay, now it's OK to upload the cofing.inc.php to the server. All right, I'm done.

1045 Access denied for user ' root ' @ ' localhost ' (using Password:yes)

1045 Access denied for user ' root ' @ ' localhost ' (using Password:yes)


The reasons are:
Your phpmyadmin set the password, but your password and mySQL Server user name and password do not cause me.

#1045-access denied for user ' root ' @ ' localhost ' (using Password:no)

The original site reproduced please indicate the source of it. www.111cn.cn

http://www.bkjia.com/PHPjc/632474.html www.bkjia.com true http://www.bkjia.com/PHPjc/632474.html techarticle today we look at the phpMyAdmin Configuration Tutorial bar, can also be called phpMyAdmin installation bar, installation I will not say, you directly to the Internet download a phpMyAdmin package extracted to your site directory ...

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