Shulou(Shulou.com)06/01 Report--

This article will give you a detailed explanation on how to deploy phpMyAdmin. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have some understanding of the relevant knowledge after reading this article.

PhpMyAdmin deployment

In LNMP WEB architecture, Nginx is a high-performance WEB server, which can not handle PHP itself. When receiving a HTTP Request request sent by a client browser, the Nginx server responds and processes the WEB request. Static resource CSS, picture, video, TXT and other static file requests can be directly processed and responded to by the Nginx server.

However, the PHP dynamic page request Nginx cannot be processed directly. The Nginx server will transfer the PHP web page script to PHP-FPM (process manager) through the interface transfer protocol (gateway protocol) PHP-FCGI (Fast-CGI). PHP-FPM does not process it, and then PHP-FPM calls the PHP parser process, and the PHP parser parses the PHP script information. Multiple PHP parser processes can be started, and multiple processes can be executed concurrently.

The PHP interpreter returns the parsed script to PHP-FPM,PHP-FPM and transmits the script information to the Nginx,Nginx server in the form of Fast-CGI and then to the browser in the form of Http Response. The browser parses and renders it and then renders it.

1. Source code installation MySQL5.7.301.1 source code compilation before installation prepare 1.1.1 because the CentOS system comes with mariadb, we need to uninstall it first. [root@node01 ~] # rpm-qa | grep mariadbmariadb-server-5.5.60-1.el7_5.x86_64mariadb-libs-5.5.60-1.el7_5.x86_64mariadb-5.5.60-1.el7_5.x86_64 [root@node01 ~] # [root@node01 ~] # yum-y remove mariadbmariadb-server mariadb-libs1.1.2 create user [root@node01 ~] # useradd-s / sbin/nologin-M mysql # prompt Mysql already exists. You can ignore this step 1.1.3 to create a directory and modify permissions [root@node01 ~] # mkdir-p / data/mysql [root@node01 ~] # chown-R mysql.mysql / data1.1.4 install MySQL related dependency package [root@node01 ~] # yum install-y gcc gcc-devel gcc-c++ gcc-c++-devel libaio* autoconf* automake* zlib* libxml* ncurses-devel ncurses libgcrypt* libtool* cmake openssl openssl-devel bison bison-devel perl-Data_ Dumper boost boost-doc boost-devel1.1.5 download the source code and extract [root@node01 ~] # cd / usr/src/ [root@node01 src] # wget http://mirrors.163.com/mysql/Downloads/MySQL-5.7/mysql-5.7.30.tar.gz[root@node01 src] # lsdebug kernels mysql-5.7.30.tar.gz [root@node01 src] # tar xf mysql-5.7.30.tar.gz [root@node01 src] # cd mysql -5.7.30 / [root@node01 mysql-5.7.30] # 1.1.6 download boost (there have been many changes since the update of version 5.7 For example, now you have to install the boost library) [root@node01 mysql-5.7.30] # mkdir. / boost [root@node01 mysql-5.7.30] # cd. / boost [root@node01 boost] # wget http://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

Description: decompression and other operations will be done when the program is compiled. Just download or copy the package here.

1.2.1 compile [root@node01 boost] # cd.. / [root@node01 mysql-5.7.30] # cmake\-DBUILD_CONFIG=mysql_release\-DCMAKE_BUILD_TYPE=RelWithDebInfo\-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\-DMYSQL_DATADIR=/data/mysql\-DSYSCONFDIR=/etc\-DMYSQL_UNIX_ADDR=/tmp/mysql.sock\-DSYSTEMD_PID_DIR=/data/mysql\-DMYSQL_USER=mysql\-DWITH_SYSTEMD=1\-DWITH_ MYISAM_STORAGE_ENGINE=1\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_ARCHIVE_STORAGE_ENGINE=1\-DWITH_MEMORY_STORAGE_ENGINE=1\-DWITH_READLINE=1\-DMYSQL_TCP_PORT=3306\-DENABLED_LOCAL_INFILE=1\-DENABLE_DOWNLOADS=1\-DWITH_PARTITION_STORAGE_ENGINE=1\-DEXTRA_CHARSETS=all\-DDEFAULT_CHARSET=utf8\-DWITH_DEBUG=0\-DMYSQL_MAINTAINER_MODE=0\-DWITH_SSL:STRING=system\-DWITH_ZLIB:STRING=bundled\-DDOWNLOAD_BOOST=1\-DWITH_BOOST= . / boost1.2.2 compilation parameters introduce cmake\-DBUILD_CONFIG=mysql_release\ # this option uses the same build options used by Oracle to configure source distribution To generate a binary distribution of the official MySQL version. -DCMAKE_BUILD_TYPE=RelWithDebInfo\ # Type of build to build = enable optimization and generate debugging information. This is the default MySQL build type. The-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\ # option indicates the basic installation directory. -DMYSQL_DATADIR=/data/mysql\ # location of the MySQL data directory. -DSYSCONFDIR=/etc\ # default my.cnf option file directory. -DMYSQL_UNIX_ADDR=/tmp/mysql.sock\ # the Unix socket file path where the server listens for socket connections. This must be an absolute pathname. The default is / tmp/mysql.sock. -DSYSTEMD_PID_DIR=/usr/local/mysql\ # the name of the directory in which the PID file is created when MySQL is managed by systemd. The default is / var/run/mysqld;, which may change implicitly depending on the INSTALL_LAYOUT value. -DMYSQL_USER=mysql\ # specify the startup user of MySQL-DWITH_SYSTEMD=1\ # install systemd support file-DWITH_MYISAM_STORAGE_ENGINE=1\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_ARCHIVE_STORAGE_ENGINE=1\-DWITH_MEMORY_STORAGE_ENGINE=1\-DWITH_READLINE=1\-DMYSQL_TCP_PORT=3306\ # configuration Port number for MySQL listening-DENABLED_LOCAL_INFILE=1\ # enables mysql clients to have the function of load data infile This feature has security concerns load data infile statements read into a table-the path of the DENABLE_DOWNLOADS=1\ # googlemock distribution from a text file at a high speed for Google Test-based unit testing. = 1 CMake will download the distribution from GitHub. -DWITH_PARTITION_STORAGE_ENGINE=1\-DEXTRA_CHARSETS=all\-DDEFAULT_CHARSET=utf8\ # server character set-DDEFAULT_COLLATION=utf8_general_ci\ # server collation-DWITH_DEBUG=0\ # does not contain debugging support. -DMYSQL_MAINTAINER_MODE=0\ # whether to enable the MySQL maintainer-specific development environment. If enabled, this option causes the compiler warning to become an error. -DWITH_SSL:STRING=system\-DWITH_ZLIB:STRING=bundled\-DDOWNLOAD_BOOST=1\ # whether to download the Boost library. The default is OFF. -DWITH_BOOST=./boost # specifies the location of the Boost library directory. 1.2.3 check whether there is an exception in compilation [root@node01 mysql-5.7.30] # echo $? # if the result returned is 0, there is no exception in compilation. 1.2.4 Source Code installs [root@node01 mysql-5.7.30] # make & & make install

It's a long process. Wait patiently.

1.2.5 check to see if there is any exception in the installation [root@node01 mysql-5.7.30] # echo $? # if the returned result is 0, the source code is compiled without exception. 1.3.1 add systemd service control [root@node01 mysql-5.7.30] # cp. / scripts/mysqld.service / usr/lib/systemd/system1.3.2 add environment variable [root@node01 mysql-5. 7.30] # cat > / etc/profile.d/mysql.sh / etc/profile.d/nginx.sh / etc/profile.d/php.sh 4.4 nginx configuration and launch # configuration phpMyAdmin [root@node01 src] # vi / usr/local/nginx/conf/nginx.conf#user nobody User nginx;worker_processes 1 domestic errorists log logs/error.log;#error_log logs/error.log notice;#error_log logs/error.log info;#pid logs/nginx.pid;pid / var/run/nginx.pid;events {worker_connections 1024;} http {include mime.types; default_type application/octet-stream Log_format main'$remote_addr-$remote_user [$time_local] "$request"'$status $body_bytes_sent "$http_referer"'"$http_user_agent"$http_x_forwarded_for"; access_log logs/access.log main; sendfile on; # tcp_nopush on; # keepalive_timeout 0; keepalive_timeout 65 # gzip on; server {listen 80; server_name localhost; # charset koi8-r; access_log logs/phpMyAdmin.access.log main; location / {root html; index index.php index.html index.htm;} # error_page 404 / 404.html # redirect server error pages to the static page / 50x.html # error_page 500 502 503 504 / 50x.html; location = / 50x.html {root html;} # proxy the PHP scripts to Apache listening on 127.0.0.1 50x.html 80 # location ~\ .php$ {# proxy_pass #} # pass the PHP scripts to FastCGI server listening on 127.0.0.1 php$ 9000 # location ~\. Php$ {root html; fastcgi_pass 127.0.0.1 php$ 9000; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include fastcgi_params } # deny access to .htaccess files, if Apache's document root # concurs with nginx's one # # location ~ /\ .ht {# deny all; #} # another virtual host using mix of IP-, name-, and port-based configuration # # server {# listen 8000; # listen somename:8080 # server_name somename alias another.alias; # location / {# root html; # index index.html index.htm; #} #} # HTTPS server # # server {# listen 443 ssl; # server_name localhost; # ssl_certificate cert.pem; # ssl_certificate_key cert.key # ssl_session_cache shared:SSL:1m; # ssl_session_timeout 5m; # ssl_ciphers High location / {# root html; # index index.html index.htm #} #}} [root@node01 src] # systemctl start nginx4.5 Test 4.5.1 enter 192.168.48.181/phpMyAdmin in the browser

4.5.2 Log in as root user

The phpMyAdmin deployment is complete.

On how to deploy phpMyAdmin to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.