lnmp环境(源码搭建)之安装MySQL
nginx mysql php (共三个需要安装 三步走)
本节为第三步:安装 mysql (最后一步)
mysql-boost-5.7.24.tar.gz(源码包)在本人博客 -我的资源- 中有上传可以自行下载
(注) 执行下列操作selinux和mysql均关闭掉:
setenforce 0 //临时关闭selinux
vim /etc/sysconfig/selinux
将SELINUX=enforcing改为SELINUX=disabled即可 //永久关闭selinux
systemctl stop firewalld //关闭防火墙
systemctl disable firewalld //禁止开机自启
本文LNMP环境搭建所用服务器为两台,一台装nginx和php服务,一台装mysql服务(vm虚拟机 centos7系统)
### 上传文件并解压
cd /usr/local/src
tar zxfv mysql-boost-5.7.24.tar.gz
cd mysql-5.7.24
### 安装cmake和依赖库
安装cmake
yum -y install cmake
安装依赖库包
yum -y install make apr* autoconf automake curl-devel gcc gcc-c++ zlib-devel openssl openssl-devel pcre-devel gd
yum -y install kernel keyutils patch perl kernel-headers compat* mpfr cpp glibc libgomp libstdc++-devel ppl
yum -y install libXpm* freetype libjpeg* libpng* php-common php-gd ncurses* libtool* libxml2 libxml2-devel
yum -y install patch wget ncurses ncurses-devel cmake make perl bison gcc* libxml2 libxml2-devel curl-devel libjpeg* freetype*
### 创建目录
```shell
useradd mysql
mkdir -p /usr/local/mysql/data/
mkdir -p /usr/local/mysql/log
chown -R mysql:mysql /usr/local/mysql/data
chown -R mysql:mysql /usr/local/mysql/log/
chmod 750 /usr/local/mysql/data
chmod 750 /usr/local/mysql/log
id mysql
配置编译安装MySQL
#配置
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DMYSQL_TCP_PORT=3306 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DWITH_BOOST=/usr/local/src/mysql-5.7.24/boost/boost_1_59_0 -DWITH_PARTITION_STORAGE_ENGINE=1
#编译
make
#安装
make install
初始化MySQL
#初始化
/usr/local/mysql/bin/mysqld --initialize --user=mysql
#报错
#解决
vim /etc/my.cnf
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
复制MySQL的启动文件
cd /usr/local/src/mysql-5.7.24
cp support-files/mysql.server /etc/init.d/
chmod +x /etc/init.d/mysql.server
启动MySQL
/etc/init.d/mysql.server start
##启动报错##
ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).
##解决办法
cd /usr/local/mysql/data
rm -rf *
登录MySQL
/usr/local/mysql/bin/mysql -uroot -p
alter user 'root'@'localhost' identified by '123456'; 修改本地密码
创建用户并授权
create user 'dev'@'%' identified by '123456'; 创建用户
grant all privileges on *.* to 'dev'@'%' with grant option; 允许 远程连接
flush privileges; 刷新权限
添加环境变量
vim /etc/profile
export MYSQL_HOME=/usr/local/mysql
PATH=$PATH:$MYSQL_HOME/bin
另一台服务器登录MySQL(安装nginx和PHP服务的服务器)
yum -y install mysql(安装mysql命令非mysql服务)
yum -y install
yum -y install mysql-devel(安装mysql扩展包)
远程登录命令mysql -h(ip地址) -u(root/dev) -p
网页访问MySQL
cd /usr/local/nginx/html/
vim test.php
<?php
$servername = "10.10.1.106"; //装有mysql服务的主机ip地址
$username = "dev"; //mysql用户名
$password = "123456"; //密码
// 创建连接
$conn = new mysqli($servername, $username, $password);
// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
echo "连接成功";
?>
PHP扩展安装mysqli
cd /usr/local/src/php-7.3.6/ext/mysqli/(先找到这个文件夹)
##增加configure
/usr/local/php/bin/phpize(输入这条命令)
#配置
./configure --prefix=/usr/local/mysqli --with-php-config=/usr/local/php/bin/php-config --with-mysqli=/usr/lib64/mysql/mysql_config
#编译
make
#安装
make install
浏览器验证:ip地址+/test.php
如果出现连接成功字样,至此lnmp环境就算搭建完成了!
解决报错
#PHP扩展安装mysqlimake时会报错
错误:致命错误:ext/mysqlnd/mysql_float_to_double.h:没有那个文件或目录
解决办法:
查找相关文件
find / -name mysql_float_to_double.h
#将文件中第34行的相对路径改为绝对路径
34 #include "/usr/local/src/php-7.3.6/ext/mysqlnd/mysql_float_to_double.h"
这时mysqli已下载,只是库没有打开,需要手动开启库
vim /usr/local/php/etc/php.ini
924(第924行)改为: extension=mysqli
#找不到mysql_config的话可能是没有安装mysql-devel
1.需要安装MySQL的源
2.yum install mysql-devel
3.这时在/etc/yum.repos.d/目录下会出现MySQL的相关repo
重启