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'] = '';
$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
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.
Please indicate the source for original reprints on this site. www.111cn.cn