day46
課堂筆記
2019年5月6日
LNMP Web服務(wù)搭建
?
數(shù)據(jù)庫產(chǎn)品：
MySQL(mariadb)、Oracle淹办、SQL SERVER、PGSQL
?
單機(jī)安裝LNMP
?
?
先裝數(shù)據(jù)庫：
1恶复、創(chuàng)建用戶
[root@web02 ~]# useradd mysql -s /sbin/nologin -M
[root@web02 ~]# id mysql
uid=1002(mysql) gid=1002(mysql)組=1002(mysql)
?
2怜森、上傳軟件到指定的目錄
[root@web02 ~]# cd /server/tools/
[root@web02 /server/tools]#
?
http://mirrors.163.com/mysql/Downloads/MySQL-5.7/
?
[root@web02 /server/tools]# ls -lsh
總用量616M
615M -rw-r--r-- 1 root root ?615M 5月 ??4 20:48 mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
0 drwxr-xr-x 9 www ?www ???204 4月 ?30 12:04 nginx-1.16.0
1012K -rw-r--r-- 1 root root 1009K 4月 ?23 21:58 nginx-1.16.0.tar.gz
?
[root@web02 /server/tools]# tar xf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
[root@web02 /server/tools]# mv mysql-5.7.26-linux-glibc2.12-x86_64 /application/mysql-5.7.26
[root@web02 /server/tools]# ln -s /application/mysql-5.7.26/ ?/application/mysql
相當(dāng)于完成以下三步了速挑。
./configure;make;make install
?
?
[root@web02 /server/tools]# ls /application/mysql/
bin ?COPYING ?docs ?include ?lib ?man ?README ?share ?support-files
?
?
3、配置配置文件/etc/my.cnf
[root@web02 /server/tools]# ls -l /etc/my.cnf #yum安裝mariadb的默認(rèn)的my.cnf
-rw-r--r--. 1 root root 570 8月 ?16 2018 /etc/my.cnf
?
rpm -e --nodeps mariadb-libs
#yum remove mariadb卸載依賴包副硅。
?
[root@web02 /server/tools]# rpm -e --nodeps mariadb-libs
[root@web02 /server/tools]# ls -l /etc/my.cnf
ls:無法訪問/etc/my.cnf: 沒有那個文件或目錄
?
?
[root@web02 /server/tools]# vim /etc/my.cnf
?
4姥宝、初始化數(shù)據(jù)庫
[root@web02 /server/tools]# rpm -qa mariadb-libs
[root@web02 /server/tools]# yum install libaio-devel -y
?
[root@web02 /server/tools]# mkdir -p /application/mysql/data
[root@web02 /server/tools]# chown -R mysql.mysql /application/mysql/
?
[root@web02 /server/tools]# /application/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/application/mysql/ --datadir=/application/mysql/data
?
?
error類似的字符串。恐疲。腊满。
?
cd /application/mysql/data
rm -fr *
?
5、配置啟動服務(wù)
?
[root@web02 /application/mysql/support-files]# cat /etc/systemd/system/mysqld.service
[Unit]
Description=MySQL Server by oldboy
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/application/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
?
?
啟動：
[root@web02 /application/mysql/support-files]# systemctl start mysqld
[root@web02 /application/mysql/support-files]# systemctl enable mysqld
Created symlink from /etc/systemd/system/multi-user.target.wants/mysqld.service to /etc/systemd/system/mysqld.service.
[root@web02 /application/mysql/support-files]# systemctl status mysqld
●mysqld.service - MySQL Server by oldboy
???Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since一 2019-05-06 09:41:25 CST; 10s ago
?????Docs: man:mysqld(8)
???????????http://dev.mysql.com/doc/refman/en/using-systemd.html
?Main PID: 7285 (mysqld)
???CGroup: /system.slice/mysqld.service
└─7285 /application/mysql/bin/mysqld --defaults-file=/etc/my.cnf
?
5月 06 09:41:25 web02 systemd[1]: Started MySQL Server by oldboy.
[root@web02 /application/mysql/support-files]# netstat -lntup|grep mysql
tcp6 ??????0 ?????0 :::3306 ????????????????:::* ???????????????????LISTEN ?????7285/mysqld ????????
[root@web02 /application/mysql/support-files]# ps -ef|grep mysql|grep -v grep
mysql ?????7285 ?????1 ?0 09:41 ? ???????00:00:00 /application/mysql/bin/mysqld --defaults-file=/etc/my.cnf
?
6培己、配置環(huán)境變量登錄
[root@web02 /application/mysql/support-files]# echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile
[root@web02 /application/mysql/support-files]# tail -1 /etc/profile
export PATH=/application/mysql/bin:$PATH
[root@web02 /application/mysql/support-files]# . /etc/profile
[root@web02 /application/mysql/support-files]# echo $PATH
/application/mysql/bin:/application/nginx/sbin:/application/nginx/sbin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin
?
[root@web02 /application/mysql/support-files]# mysql
Welcome to the MySQL monitor. ?Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
oldboy [(none)]>
成功登錄碳蛋。
oldboy [(none)]>quit
Bye
?
如果出錯就看錯誤日志：
日志文件
cat /application/mysql/data/oldboy_mysql.err
?
?
7、修改密碼
mysqladmin -u root password 'oldboy123'
?
重新登錄：
交互式登錄：
[root@web02 ~]# mysql -uroot -p
Enter password:
非交互登錄：
mysql -uroot -poldboy123
?
?
課程：
期中架構(gòu)以后會有10-15數(shù)據(jù)庫講解
周末班專業(yè)DBA課程省咨。
數(shù)據(jù)庫要學(xué)的東西很少肃弟，而且變化慢：
?
1、mysql,orcale,redis,mongodb,ELK
2零蓉、差異化自己笤受，工資更高。
?
?
?
安裝PHP：
YUM安裝：簡單敌蜂、方便箩兽、高效。
編譯安裝PHP
?
1章喉、安裝PHP調(diào)用的庫
yum install zlib-devel libxml2-devel libjpeg-devel libjpeg-turbo-devel libiconv-devel -y
yum install freetype-devel libpng-devel gd-devel libcurl-devel libxslt-devel libxslt-devel -y
?
cd /server/tools/
上傳libiconv-1.16.tar.gz
?
tar zxf libiconv-1.16.tar.gz
cd libiconv-1.16
./configure --prefix=/application/libiconv
make
make install
cd ../
?
yum install libmcrypt-devel -y
yum install mhash -y
yum install mcrypt -y
?
?
2汗贫、安裝PHP
cd /server/tools/
tar xf php-7.3.5.tar.gz
cd php-7.3.5/
?
./configure \
--prefix=/application/php-7.3.5 \
--enable-mysqlnd ?\
--with-mysqli=mysqlnd \
--with-pdo-mysql=mysqlnd \
--with-iconv-dir=/application/libiconv \
--with-freetype-dir \
--with-jpeg-dir \
--with-png-dir \
--with-zlib \
--with-libxml-dir=/usr \
--enable-xml \
--disable-rpath \
--enable-bcmath \
--enable-shmop \
--enable-sysvsem \
--enable-inline-optimization \
--with-curl \
--enable-mbregex \
--enable-fpm \
--enable-mbstring \
--with-gd \
--with-openssl \
--with-mhash \
--enable-pcntl \
--enable-sockets \
--with-xmlrpc \
--enable-soap \
--enable-short-tags \
--enable-static \
--with-xsl \
--with-fpm-user=nginx \
--with-fpm-group=nginx \
--enable-ftp \
--enable-opcache=no
?
make
make install
?
?
[root@web02 /server/tools/php-7.3.5]# echo $?
0
?
聽話，出活秸脱÷浒——老男孩
跑通在變通∽卜矗——老男孩
?
7.2拋棄了妥色。
--with-mysql=/application/mysql編譯PHP時候使用mysql軟件下面的庫文件搪花。
--enable-mysqlnd帶mysql庫文件
?
?
將nginx的用戶和PHP的用戶統(tǒng)一：nginx
[root@web02 /server/tools/php-7.3.5]# useradd nginx -u 1111 -s /sbin/nologin -M
[root@web02 /server/tools/php-7.3.5]# id nginx
uid=1111(nginx) gid=1111(nginx)組=1111(nginx)
?
?
[root@web02 /server/tools/php-7.3.5]# vim /application/nginx/conf/nginx.conf
worker_processes ?1;
user ?nginx nginx;
（編譯的時候就改用nginx）
?
[root@web02 ~]# ln -s /application/php-7.3.5/ /application/php
[root@web02 ~]# ls /application/php/
bin ?etc ?include ?lib ?php ?sbin ?var
?
3遏片、配置php.ini（PHP解析器配置文件）
?
[root@web02 /application/php]# cd /server/tools/php-7.3.5/
[root@web02 /server/tools/php-7.3.5]# ls php.ini-*
php.ini-development ?php.ini-production
?
[root@web02 /server/tools/php-7.3.5]# cp php.ini-development /application/php/lib/php.ini
[root@web02 /server/tools/php-7.3.5]# ls -l /application/php/lib/php.ini
-rw-r--r-- 1 root root 71648 5月 ??6 11:51 /application/php/lib/php.ini
?
?
4、配置PHP FPM
[root@web02 /server/tools/php-7.3.5]# cd /application/php/etc/
[root@web02 /application/php/etc]# ls
pear.conf ?php-fpm.conf.default ?php-fpm.d
[root@web02 /application/php/etc]# cp php-fpm.conf.default php-fpm.conf
[root@web02 /application/php/etc]# cd php-fpm.d/
[root@web02 /application/php/etc/php-fpm.d]# ls
www.conf.default
[root@web02 /application/php/etc/php-fpm.d]# cp www.conf.default www.conf
[root@web02 /application/php/etc/php-fpm.d]# ls
www.conf ?www.conf.default
?
5撮竿、啟動PHP服務(wù)
[root@web02 /application/php/etc/php-fpm.d]# /application/php/sbin/php-fpm
[root@web02 /application/php/etc/php-fpm.d]#
tcp ???????0 ?????0 127.0.0.1:9000 ?????????0.0.0.0:* ??????????????LISTEN ?????12214/php-fpm: mast
?
?
6吮便、開機(jī)自啟動
[root@web02 /application/php/etc/php-fpm.d]# tail -2 /etc/rc.local
/application/nginx/sbin/nginx
/application/php/sbin/php-fpm
?
?
7、配置nginx轉(zhuǎn)發(fā)PHP請求
????????location ~ .*\.(php|php5)?$ {
????????????root html/blog;
????????????fastcgi_pass ?127.0.0.1:9000;
????????????fastcgi_index index.php;
????????????include fastcgi.conf;
????????}
?
[root@web02 /application/nginx/conf]# cat extra/03_blog.conf
????server {
????????listen ??????80;
????????server_name ?blog.etiantian.org;
????????root ??html/blog;
????????location / {
????????????index ?index.html index.htm;
????????}
????????location ~ \.php$ {
????????????fastcgi_pass ??127.0.0.1:9000;
????????????fastcgi_index ?index.php;
????????????fastcgi_param ?SCRIPT_FILENAME ?/scripts$fastcgi_script_name;
????????????include ???????fastcgi_params;
????????}
?
????}
?
編寫測試文件
[root@web02 /application/nginx/conf]# echo "<?php phpinfo(); ?>" > ../html/blog/test_info.php
[root@web02 /application/nginx/conf]# cat ../html/blog/test_info.php
<?php phpinfo(); ?>
?
[root@web02 /application/nginx/conf]# /application/php/bin/php /application/nginx/html/blog/test_info.php
?
成功的配置：
[root@web02 /application/nginx/conf/extra]# cat 03_blog.conf
server {
????????listen ??????80;
????????server_name ?blog.etiantian.org;
????????location / {
????????????root ??html/blog;
????????????index ?index.html index.htm;
????????}
????????location ~ .*\.(php|php5)?$ {
????????????root html/blog;
????????????fastcgi_pass ?127.0.0.1:9000;
????????????fastcgi_index index.php;
????????????include fastcgi.conf;
????????}
????}
錯誤的配置
[root@web02 /application/nginx/conf/extra]# cat 03_blog.conf.ori
????server {
????????listen ??????80;
????????server_name ?blog.etiantian.org;
????????root ??html/blog;
????????location / {
????????????index ?index.html index.htm;
????????}
????????location ~ \.php$ {
????????????fastcgi_pass ??127.0.0.1:9000;
????????????fastcgi_index ?index.php;
????????}
?
????}
?
?
[root@web02 /application/nginx/conf]# nginx -t
nginx: the configuration file /application/nginx-1.16.0//conf/nginx.conf syntax is ok
nginx: configuration file /application/nginx-1.16.0//conf/nginx.conf test is successful
[root@web02 /application/nginx/conf]# nginx -s reload
?
?
8幢踏、測試PHP連接mysql
[root@web02 /application/nginx/html/blog]# cat ?/application/nginx/html/blog/test_mysql.php
<?php
//$link_id=mysqli_connect('主機(jī)名','用戶','密碼');
$link_id=mysqli_connect('localhost','root','oldboy123') or mysql_error();
if($link_id){
echo "mysql successful by oldboy.\n";
}else{
echo mysql_error();
}
?>
?
[root@web02 /application/nginx/html/blog]# /application/php/bin/php /application/nginx/html/blog/test_mysql.php
mysql successful by oldboy.
?
http://blog.etiantian.org/test_mysql.php
?
LNMP環(huán)境搭建成功髓需。
