centos7编译安装mysql5.7
来源:互联网 发布:mac添加桌面小组件 编辑:程序博客网 时间:2024/06/05 21:16
安装依赖:
yum -y install gcc cmake make gcc-c++ ncurses-devel openssl-devel bison ncurses chkconfig lsof
创建用户组及用户:
groupadd mysql useradd -g mysql mysql
创建mysql相关目录:
mkdir /usr/local/mysqlchown mysql.mysql -R /usr/local/mysql/mkdir -p /var/mysql/mkdir -p /var/mysql/data/mkdir -p /var/mysql/log/chown mysql.mysql -R /var/mysql/
下载及解压boost:
wget https://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gztar -zxvf boost_1_59_0.tar.gz mv boost_1_59_0 /usr/local/
下载及解压mysql:
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gztar -zxvf mysql-5.7.17.tar.gz cd mysql-5.7.17
编译及安装(每条配置以一个空格隔开,结果空格加.):
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -j `grep processor /proc/cpuinfo | wc -l` -DMYSQL_DATADIR=/var/mysql/data -DWITH_BOOST=/usr/local/boost_1_59_0 -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS:STRING=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DMYSQL_USER=mysql .make && make install
创建mysql配置文件:
mv /etc/my.cnf /etc/my.cnf-`date +%F` cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
将MySQL数据库的动态链接库共享至系统链接库,这样MySQL服务就可以被其它服务调用了:
ln -s /usr/local/mysql/lib/libmysqlclient.so.20 /usr/lib/libmysqlclient.so.20
加入运行环境:
echo pathmunge /usr/local/mysql/bin after > /etc/profile.d/mysql.sh . /etc/profile
设置开机启动:
chmod 755 /etc/init.d/mysqldchkconfig --add mysqldchkconfig --level 345 mysqld on
初始化库:
mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/var/mysql/data
启动mysql:
/etc/init.d/mysqld start service mysqld restart
阅读全文
0 0
- centos7 mysql5.7编译安装
- centos7 编译安装mysql5.7+
- centos7编译安装mysql5.7
- centos7中编译安装mysql5.7
- CentOS7 编译安装MySQL5.6.22
- CentOS7编译安装MySQL5.7.10
- Centos7 编译安装mysql5.6
- Centos7编译安装mysql5.7.18
- CentOS7安装MySQL5.7
- centos7安装mysql5.7
- CentOS7安装MySQL5.7
- centos7安装mysql5.7
- Centos7 安装Mysql5.7
- centos7 安装mysql5.7
- CentOS7-安装MySQL5.7
- CentOS7 安装MySQL5.7
- CentOS7 MySQL5.7安装
- Centos7安装Mysql5.7
- ubuntu安装JLink 驱动。终结总结
- 网络端口
- .\与..\的区别
- 快速排序算法及优化
- 集合框架-Iterator
- centos7编译安装mysql5.7
- 装系统
- MFC/C++创建单级目录与多级目录
- CSDN日报20170619 ——《深度学习,先跟上再说》
- 数学问题——最大公约数和最小公倍数(辗转相除法)
- bootstrap model弹出框的使用
- ViewPage用fragment填充
- “插件(application/x-vlc-plugin)不受支持”NPAPI和PPAPI的问题
- 全选与取消【jQuery实例】