Installation deployment for phpMyAdmin

System Environment: CENTOS7

PHP Version: 5.3.27

phpMyAdmin version: 4.2.7.1

ip:192.168.1.205

Database: mysql5.5.32

This deployment uses Nginx

Download phpMyAdmin:

wget Https://files.phpmyadmin.net/phpMyAdmin/4.2.7.1/phpMyAdmin-4.2.7.1-all-languages.zip

1. Install PHP and Nginx, MySQL (slightly)

2. Unzip the file

Unzip the file to/usr/local/nginx/html/and change the directory to phpMyAdmin

Cd/usr/local/nginx/html

Unzip Phpmyadmin-4.2.7.1-all-languages.zip && MV Phpmyadmin-4.2.7.1-all-languages phpMyAdmin

2. Configure Nginx

[[email protected] conf]# cat 205.conf server {         server_tokens off;        listen        80;                  #listen        443;          #if   ($http _user_agent ~*  "Chrome")          #{         #        return 403;        #}         server_name  192.168.1.205;        index  index.php index.html index.htm;        root html;        &nbsP; location ~ .*\. (PHP|PHP5)?$ {             #root             bbs;             fastcgi_pass   127.0.0.1:9000;             fastcgi_index  index.php;              #fastcgi_param   script_filename  /scripts$fastcgi_ script_name;             #include          fastcgi_params;             include   fastcgi.conf;            # auth_basic           "Xiaoyao site";              #auth_basic_user_file  conf/htpasswd;         }}

4, Configuration phpMyAdmin

Place the file libraries/config.default.php in the phpMyAdmin home directory:

[Email protected] phpmyadmin]# cp/usr/local/nginx/html/phpmyadmin/libraries/config.default.php/usr/local/nginx/ html/phpmyadmin/config.inc.php

Start PHP:

[Email protected] phpmyadmin]#/APPLICATION/PHP/SBIN/PHP-FPM

Restart Nginx:

[Email protected] phpmyadmin]#/usr/local/nginx/sbin/nginx-s Reload

Start MySQL:

/etc/init.d/mtsqld start

5. Visit phpMyAdmin

Enter a link in the Address bar:

http://192.168.1.205/phpmyadmin/index.php

Enter the database's account password to log in.

Of course, you can also pass

http://192.168.1.205/phpmyadmin/setup/index.php

Create more than one server. Then repeat the 4th step.

Problems encountered:

1. Enter your username and password and click " Execution " after always reported "#2002 unable to log in MySQL Server " .

Baidu has found a solution that will "PhpMyAdmin" folder under the config.inc.php in the file

$cfg [' Servers '] [$i] [' host '] = ' localhost ';

Revision changed to

$cfg [' Servers '] [$i] [' host '] = ' 127.0.0.1 ';

It's settled.

aMySQLcustomers can connect in two different waysmysqldServer:Unixsocket, which passes through a file in the file system(default"/tmp/mysqld.sock")to connect, orTCP/IP, which is connected by a port number. UnixSocket ratioTCP/IPfaster, but only for servers connected to the same computer. If you do not specify a host name or if you specify a special hostnamelocalhost, usingUnixsockets.
Error(2002)Can ' t connect to ...usually means that there is not aMySQLthe server is running on the system or when trying to connectmysqldserver, you are using an incorrect socket file orTCP/IPPort.
by Check(UsePS)On your server, there is a name ofmysqldthe process starts! If you do not have anymysqldprocess, you should start one.

2.phpmyadmin #1045错误, unable to log on to MySQL server

This problem is caused by a blank password, the corresponding user in the database with the password on the line, if the first problem, then the password to be added to the user should be ' user name ' @127.0.0.1.

Installation deployment for phpMyAdmin