中文 
q2144899870 
deepin
2018-08-30 00:16 deepin 如何搭建直播系统LNMP环境，下面先教如何配置mysql。一、前期准备1.关闭防火墙及selinux 4.安装libmcrypt （加密算法扩展库，支持DES, 3DES, RIJNDAEL, Twofish, IDEA, GOST, CAST-256, ARCFOUR, SERPENT, SAFER+等算法) 5.安装mhash（Mhash是基于离散数学原理的不可逆向的php加密方式扩展库，其在默认情况下不开启。 mhash的可以用于创建校验数值，消息摘要，消息认证码，以及无需原文的关键信息保存） 6.安装mcript（mcrypt 是 php 里面重要的加密支持扩展库，Mcrypt扩展库可以实现加密解密功能，就是既能将明文加密，也可以密文还原。） 7.亦可以通过以下两种方法增加库文件 5.初始化mysql数据库
service iptables stop
chkconfig iptables off
setenforce 0
vi /etc/sysconfig/selinux
SELINUX=disabled #enforcing改为disabled
2.依赖包安装yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel openldap-clients openldap-servers make libtool* git tree bison pcre-devel perl gd gd-devel
3.安装libiconv（支持编码转换为函数）tar xf libiconv-1.14.tar.gz
cd libiconv-1.14/
./configure --prefix=/usr/local make && make install
tar xf libmcrypt-2.5.8.tar.gz
cd libmcrypt-2.5.8
./configuremake && make install
cd libltdl/
./configure --enable-ltdl-install #加载动态库make && make install
tar xf mhash-0.9.9.9.tar.bz2
cd mhash-0.9.9.9
./configure
make && make install
cd /usr/local/src
tar zxvf mcrypt-2.6.8.tar.gz cd mcrypt-2.6.8/ export LD_LIBRARY_PATH=/usr/local/lib
LD_LIBRARY_PATH #暂时生效
LD_LIBRARY_PATH #暂时生效./configure
make && make install
ln -s /usr/local/lib/libmcrypt.la /usr/lib/libmcrypt.la
ln -s /usr/local/lib/libmcrypt.so /usr/lib/libmcrypt.so
ln -s /usr/local/lib/libmcrypt.so.4 /usr/lib/libmcrypt.so.4
ln -s /usr/local/lib/libmcrypt.so.4.4.8 /usr/lib/libmcrypt.so.4.4.8
ln -s /usr/local/lib/libmhash.a /usr/lib/libmhash.a
ln -s /usr/local/lib/libmhash.la /usr/lib/libmhash.la
vim /etc/ld.so.conf
/usr/local/lib/
ldconfig
8.安装cmake （MySQL从5.5版本开始，通过./configure进行编译配置方式已经被取消，取而代之的是cmake工具）tar xf cmake-3.4.1.tar.gz
cd cmake-3.4.1
./bootstrap
make && make install
二、MySQL安装1.新增mysql用户groupadd -r mysql
useradd -r -g mysql mysql
2.新建MySQL所需目录mkdir -p /usr/local/mysql
mkdir -p /data/mysqldb
3.编译安装tar xf mysql-5.6.23.tar.gz
cd mysql-5.6.23
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1-DMYSQL_DATADIR=/data/mysqldb -DMYSQL_TCP_PORT=3306 -DENABLE_DOWNLOADS=1-DSYSCONFDIR=/etc -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0
make&& make install
4.修改mysql目录权限cd /usr/local/mysql
chown -R mysql:mysql .
cd /data/mysqldb
chown -R mysql:mysql .
cd /usr/local/mysql./scripts/mysql_install_db --user=mysql --datadir=/data/mysqldb
6.编译修改/etc/my.cnf[mysql]
# CLIENT #port = 3306socket = /data/mysqldb/mysql.sock
[mysqld]
# GENERAL #user = mysqldefault-storage-engine = InnoDBsocket = /data/mysqldb/mysql.sockpid-file = /data/mysqldb/mysql.pid
# MyISAM #key-buffer-size = 32Mmyisam-recover = FORCE,BACKUP
# SAFETY #max-allowed-packet = 16Mmax-connect-errors = 1000000
# DATA STORAGE #datadir = /data/mysqldb/
# BINARY LOGGING #log-bin
7.复制MySQL启动文件及其命令加入PATHcp support-files/mysql.server /etc/init.d/mysqld
vim /etc/profile.d/mysql.sh
PATH=/usr/local/mysql/bin:/usr/local/mysql/libPATH
PATH export PATH
source /etc/profile.d/mysql.sh
8.启动MySQL并增加启动项service mysqld start
chkconfig mysqld on
9.设置MySQL登录权限drop user ''@localhost;drop user ''@hostname;update mysql.user set password=password('*******');flush privileges;
到这里，MySQL编译完成 Reply Like 0 Favorite View the author
【Enhanced Repo】Better Deepin Repo is released 
