Home > Backend Development > PHP Tutorial > phpmyadmin configuration method and installation tutorial_PHP tutorial

phpmyadmin configuration method and installation tutorial_PHP tutorial

WBOY
Release: 2016-07-13 10:52:44
Original
1185 people have browsed it

Today we will take a look at the phpmyadmin configuration tutorial, it can also be called phpmyadmin installation . I won’t go into the installation. You can directly Just download a phpmyadmin package from the Internet and unzip it to your site directory. Let’s look at a simple example below.

Installation directory:/admin/

Okay, now let’s open the folder we just unzipped and find config.sample.inc.php and rename it to config.inc.php. Next we will open this file.

Found

$cfg['PmaAbsoluteUri'] = '';
$cfg['EexecTimeLimit'] = ;

We set $cfg['PamAbsolteUri] to your directory, mine is the /admin/ directory, $cfg['EexecTimeLimit'] I set to 10000

$cfg['PmaAbsoluteUri'] = '/admin/''';
$cfg['EexecTimeLimit'] = 10000;

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

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

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

Here is the setting to connect to the mysql host, which can be the host or the IP address.

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

Find it below.

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

I won’t go into details about the above three meanings. Please take a 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'] = '******'; This is your mysql password

Okay, now it’s OK to upload cofing.inc.php to the server. Okay, it’s finished

1045 Access denied for user 'root'@'localhost' (using password: YES)

1045 Access denied for user 'root'@'localhost' (using password: YES)



The reason is:
You have set a password for your
phpmyadmin, but your password is not the same as mysql server username and password.

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Please indicate the source for original reprints on this site. www.111cn.cn

http://www.bkjia.com/PHPjc/632474.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/632474.htmlTechArticleToday we will take a look at the phpmyadmin configuration tutorial, which can also be called phpmyadmin installation. I won’t go into the installation. You can directly download a phpmyadmin package from the Internet and unzip it to your site directory...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template