phpmyadmin configuration method and installation tutorial_PHP tutorial

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