Phpmyadmin configuration method and installation tutorial

Let's take a look today.Phpmyadmin configuration tutorialIt can also be calledPhpmyadmin InstallationI won't talk about the installation. You can downloadPhpmyadminDecompress the package to your site directory. Here is a simple example.

Installation Directory:/admin/

Now, open the decompressed folder and find config. sample. inc. php. rename it config. inc. php. Then, open the file.

Find

$ Cfg ['pmaabsoluteuri '] = '';
$ Cfg ['eexectimelimmit '] =;

We set $ cfg ['pamabsolteuri] To your directory. My directory is/admin/, and $ cfg ['eexectimelimit '] to 10000.

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

Find $ cfg ['blowfish _ secret'] = '';

$ Cfg ['blowfish _ secret'] = 'cooker ';

Find $ cfg ['servers'] [$ I] ['host'] = ''// MySQL hostname or IP address

The connection to the mysql host can be either a host or an IP address.

$ Cfg ['servers'] [$ I] ['host'] = 'localhost'; // MySQL hostname or IP address

Next, find.

$ 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'] = '';

I will not talk much about the above three meanings. Let's look at my configuration.

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker'; // 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.

Now, upload cofing. inc. php to the server.

 

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

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


The reason is:
YourPhpmyadminThe password is set, but your password and mysql server user name and password are not caused by me.

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

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