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

Php mysql source code installation is what, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Php mysql source code installation method: 1, install the dependency package through yum and compile and install mysql source code; 2, through the "yum install" command to install PHP source code and modify the configuration; 3, install nginx source code and test the installation results.

This article operating environment: redhat6.5 system, PHP5.6, Dell G3 computer.

Php mysql source code installation tutorial

Source code compilation and installation of mysql and php

Mysql source code compilation installation installation dependent package: yum install cmake-2.8.12.2-4.el6.x86_64.rpm gcc-c++ ncurses-devel gcc- y [root@server2 ~] # lsanaconda-ks.cfg haproxy-1.6.11.tar.gz lamp nginxdrbd-8.4.3 heartbeat-3.0.4-2.el6.x86_64.rpm mysql- 5.7.11 php-5.6.20.tar.bz2drbd-8.4.3.tar.gz heartbeat-libs-3.0.4-2.el6.x86_64.rpm mysql-boost-5.7.11.tar.gz rpmbuild [root@server2 ~] # tar zxf mysql-boost-5.7.11.tar.gz [root@server2 ~] # cd mysql-5.7.11/

Compile parameters:

Cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\ # installation directory-DMYSQL_DATADIR=/usr/local/mysql/data\ # database storage directory-DMYSQL_UNIX_ADDR=/usr/local/mysql/data/mysql.sock\ # Unix socket file path-DWITH_MYISAM_STORAGE_ENGINE=1\ # install myisam storage engine-DWITH_INNOBASE_STORAGE_ENGINE=1\ # install innodb storage engine-DWITH_ARCHIVE_STORAGE_ENGINE=1\ # install archive storage engine-DWITH _ BLACKHOLE_STORAGE_ENGINE=1\ # install blackhole Storage engine-DWITH_PARTITION_STORAGE_ENGINE=1\ # install Database Partition-DENABLED_LOCAL_INFILE=1\ # allow data to be imported locally-DWITH_READLINE=1\ # Shortcut key function-DWITH_SSL=yes\ # support SSL-DDEFAULT_CHARSET=utf8\ # enable utf8 characters-DDEFAULT_COLLATION=utf8_general_ci\ # check characters-DEXTRA_CHARSETS=all\ # install all extended character sets-DMYSQL_TCP_PORT=3306\ # MySQL snooping Port [root@server2mysql-5.7.11] # cmake\-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\-DMYSQL_DATADIR=/usr/local/mysql/data\-DMYSQL_UNIX_ADDR=/usr/local/mysql/data/mysql.sock\-DWITH_MYISAM_STORAGE_ENGINE=1\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_ARCHIVE_STORAGE_ENGINE=1\-DWITH_BLACKHOLE_STORAGE_ENGINE=1\-DWITH_PARTITION_STORAGE_ENGINE=1\-DENABLED_LOCAL_INFILE=1\-DWITH_READLINE=1-DWITH_ SSL=yes\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8_general_ci\-DEXTRA_CHARSETS=all-DMYSQL_TCP_PORT=3306\-DWITH_BOOST=boost/boost_1_59_0/ [root @ server2mysql-5.7.11] make [root@server2mysql-5.7.11] make install [root@server1 support-files] # cp / etc/my.cnf / etc/my.cnf.bak # backup [root@server1 support-files] # cp my-default.cnf / etc/my.cnf # create a new my. Cnf file [root@server1 support-files] # vim / etc/my.cnf 18 basedir = / usr/local/lnmp/mysql 19 datadir = / usr/local/lnmp/mysql/data 20 port = 3306 21 # server_id =. 22 socket = / usr/local/lnmp/mysql/data/mysql.sock [root@server1 support-files] # cp mysql.server / etc/init.d/mysqld # copy the script to the startup script directory [root@server1 mysql] # chmod + x / etc/init.d/mysqld # give script execution permission [root@server1 mysql] # groupadd-g 27 mysql # create mysql group [root@server1 mysql] # useradd-M-s / sbin/nologin-d / usr/local/lnmp / mysql/data-u 27 mysql-g mysql # create mysql user [root@server1 mysql] # chown mysql:mysql-R. # change the owner of all files in the directory to nysql [root@server1 mysql] # mysqld-- verbose-- help | grep 'insecure' # filter the parameter needed for initialization-- initialize-insecure insecure transport will be rejected. Secure transportsinitialize-insecure FALSE [root@server1 mysql] # mysqld-initialize-insecure-user=mysql2017-09-26T03:54:01.520645Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use-explicit_defaults_for_timestamp server option (see documentation for more details). 2017-09-26T03:54:01.521056Z 0 [Warning] 'NO_ZERO_DATE',' NO_ZERO_IN_DATE' and 'ERROR_FOR_pISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.2017-09-26T03:54:01.521075Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2017-09-26T03:54:01.528325Z 0 [ERROR]-- initialize specified but the data directory has files in it. Aborting. # data 2017-09-26T03:54:01.529162Z 0 [ERROR] Aborting [root@server1 mysql] # cd data/ [root@server1 data] # lsauto.cnf client-cert.pem ibdata1 ibtmp1 mysql.sock private_key.pem server1.pid sysca-key.pem client-key.pem ib_logfile0 mysql mysql.sock.lock public_key.pem server-cert.pemca.pem in data directory Ib_buffer_pool ib_logfile1 mysqld_safe.pid performance_schema server1.err server-key.pem [root@server1 data] # rm-fr * # Delete data under data [root@server1 mysql] # mysqld-- initialize-insecure-- user=mysql # initialize the database [root@server1 data] # vim ~ / .bash_profile # add environment variables 8 # User specific environment and startup programs 9 10 PATH=$PATH:$HOME/bin:/usr/local/lnmp/mysql to the database / bin [root@server1 data] # / etc/init.d/mysqld start # start the database Starting MySQL. SUCCESS! [root@server1 data] # mysql_secure_installation # enter the security work of the database for the first time, set the mysql password, and log in to anonymous users. Set [root@server2 data] # mysql [root@server2 data] # chown root:root data/-R # to root users with mysql data directory permissions for security. Commands end with; or\ g.Your MySQL connection id is 2Server version: 5.7.11 Source distributionCopyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c' to clear the current input statement.mysql > show databases;+-+ | Database | +-+ | information_schema | | mysql | | performance_schema | | sys | +-+ 4 rows in set (0.00 sec) mysql > quit

Note: if the following error is found because mysql is not initialized, there will be no such problem after mysqld-initialize-insecure-user=mysql restarts the database.

[root@server2 bin] # / etc/init.d/mysqld startStarting MySQL... ERROR! The server quit without updating PID file (/ usr/local/mysql/data//server2.pid). Dependent package for php source code installation: yum install libxml2-devel-yyum reinstall libcurl- yyum install libcurl-devel.x86_64-ylibjpeg-turbo-devel-1.2.1-1.el6.x86_64-yyum install gd-devel-2.0.35-11.el6.x86_64.rpm-yyum install gmp-devel-yyum install libmcrypt-2.5.8-9.el6.x86 _ 64.rpm-yyum install libmcrypt-devel-2.5.8-9.el6.x86_64.rpm-yyum install net-snmp-devel-yyum install re2c-0.13.5-1.el6.x86_64.rpm-y

Compilation and installation

Root@server1 lamp] # tar jxf php-5.6.20.tar.bz2 [root@server1 php-5.6.20] #. / configure\-- prefix=/usr/local/lnmp/php\-- with-config-file-path=/usr/local/lnmp/php/etc\-- with-mysql=mysqlnd\-- with-openssl\-- with-snmp\-- with-gd\-- with-zlib\-with-curl\-- with-libxml-dir\-- with-png- Dir\-- with-jpeg-dir\-- with-freetype-dir\-- with-pear\-- with-gettext\-- with-gmp\-- enable-inline-optimization\-- enable-soap\-- enable-ftp\-- enable-sockets\-- enable-mbstring\-- with-mysqli=mysqlnd\-- enable-fpm\-with-fpm-user=nginx\-with-fpm-group=nginx\-- with-mcrypt\-- with-mhash [root@server1 php-5.6.20] # useradd-M-s / sbin/nologin-d / usr/local/lnmp/mysql/-u 1500 nginx [root@server1 php-5.6.20] # make & & make install basic configuration php [root@server1 php-5.6.20] # cp php.ini-production / usr/local/lnmp/php/etc/php.ini [root@server1 php-5.6.20] # cp sapi/fpm/init.d.php-fpm / etc/init.d/php-fpm [root@ Server1 php-5.6.20] # chmod + x / etc/init.d/php-fpm [root@server1 php-5.6.20] # cd / usr/local/lnmp/php/ [root@server1 php] # lsbin etc include lib php sbin var [root@server1 php] # vim etc/php.ini 923 Defines the default timezone used by the date functions 924; http://php.net/date.timezone 925 date.timezone = Asia/Shanghai # time zone 926 [root@server1 etc] # vim php-fpm.conf 24; Default Value: none 25 pid = run/php-fpm.pid # Open pid 26 [root@server1 etc] # vim php.ini 1000; http://php.net/pdo_mysql.default-socket1001 pdo_mysql.default_socket=/usr/local/lnmp/mysql/data/mysql.sock...1149 Http://php.net/mysql.default-socket1150 mysql.default_socket = / usr/local/lnmp/mysql/data/mysql.sock...1209 mysqli.default_socket = / usr/local/lnmp/mysql/data/mysql.sock1210 [root@server1 etc] # / etc/init.d/php-fpm startStarting php-fpm done

Nginx source code installation

[root@server1] # cd nginx-1.12.0 [root@server1 nginx-1.12.0] # lsauto CHANGES.ru configure html Makefile objs srcCHANGES conf contrib LICENSE man README [root@server1 nginx-1.12.0] #. / configure-- prefix=/usr/local/lnmp/nginx\-- with-threads\-- with-http_ssl_module\-- with-file-aio\-- with-http_stub_status _ module [root@server1 nginx-1.12.0] # make & & make install [root@server1 nginx-1.12.0] # ln-s / usr/local/lnmp/nginx/sbin/nginx / usr/local/sbin/ [root@server1 nginx-1.12.0] # vim / usr/local/lnmp/nginx/conf/nginx.conf 42 location / {43 root html 44 index index.php index.html index.htm; 45} # add php release page 64 location ~\ .php$ {65 root html; 66 fastcgi_pass 127.0.0.1 php$ 9000; 67 fastcgi_index index.php; 68 fastcgi_param SCRIPT_FILENAME / scripts$fastcgi_script_name; 69 include fastcgi.conf # modified to this 70} [root@server1 html] # cat index.php # php release page [root@server1 html] # nginx-s reload [root@server1 html] # / etc/init.d/php-fpm reloadReload service php-fpm done

Test:

172.25.32.1 in browser

After reading the above, have you mastered the method of installing php mysql source code? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.