源码安装MySQL

最新推荐文章于 2024-06-02 14:54:06 发布

芙宁娜~

最新推荐文章于 2024-06-02 14:54:06 发布

阅读量112

点赞数 5

文章标签： mysql linux

本文链接：https://blog.csdn.net/sakana12138/article/details/134296413

版权

一：准备环境

1.关闭selinux和防火墙

# systemctl stop firewalld && systemctl disable firewalld
#selinux

# setenforce 0

# sed -i.bak 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

# getenforce

2.测试能否访问公网

# ping -W1 -c3 www.baidu.com

PING www.a.shifen.com (14.119.104.254) 56(84) bytes of data.
64 bytes from 14.119.104.254 (14.119.104.254): icmp_seq=1 ttl=55 time=33.9 ms
64 bytes from 14.119.104.254 (14.119.104.254): icmp_seq=2 ttl=55 time=38.0 ms
64 bytes from 14.119.104.254 (14.119.104.254): icmp_seq=3 ttl=55 time=34.7 ms

--- www.a.shifen.com ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2002ms
rtt min/avg/max/mdev = 33.973/35.572/38.023/1.766 ms-- ms

二：清理环境

# yum -y erase mariadb mariadb-server mariadb-libs mariadb-devel
userdel -r mysql

# rm -rf /etc/my*

# rm -rf /var/lib/mysql

三：部署MySQL

1.安装依赖包

# yum -y groupinstall "Development Tools"

# yum -y install ncurses ncurses-devel openssl-devel bison libgcrypt gcc gcc-c++ make cmake

2.添加MySQL用户

# useradd mysql

3.创建所需要的目录

# mkdir -p /usr/local/{data,log,tmp,mysql}

4.修改权限

# chown mysql.mysql /usr/local/{data,log,tmp,mysql}

5.上传源码包

# rz （上传阿里镜像站下载的MySQL源码包）

6.解压并编译

# tar -xf mysql-boost-5.7.40.tar.gz

# cd mysql-5.7.40

# cmake . \
-DWITH_BOOST=boost/boost_1_59_0/ \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/etc \
-DMYSQL_DATADIR=/usr/local/data \
-DINSTALL_MANDIR=/usr/share/man \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_UNIX_ADDR=/usr/local/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_SSL=system \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1

# make && make install

四：修改权限

# chown -R mysql.mysql /usr/local/mysql

五：初始化数据库

# cd /usr/local/mysql

# ./bin/mysqld --user="mysql" --initialize

六：配置文件

# vim /etc/my.cnf #进入后摁 i 写入下方内容去掉汉字

[mysqld]
basedir = /usr/local/mysql #安装目录
datadir = /usr/local/data #数据存放目录
tmpdir = /usr/local/tmp #/tmp缓存目录
socket = /usr/local/tmp/mysql.sock #指定socket文件的位置
pid_file = /usr/local/tmp/mysqld.pid #指定pid文件的位置
log_error = /usr/local/log/mysql_error.log #错误日志的位置
slow_query_log_file = /usr/local/log/slow_warn.log #慢日志查询

server_id = 1 #server-id=？？
user = mysql #指定用户
port = 3306 #指定端口
bind-address = 0.0.0.0 #监听地址（允许所以ip访问）
character-set-server = utf8 #字符集
default_storage_engine = InnoDB #引擎

七：配置环境变量

# echo "export PATH=/usr/local/mysql/bin:$PATH" >> /etc/profile

# source /etc/profile

八：启动数据库

[root@xa2305 ~]# ./bin/mysqld_safe --user="mysql"

如果失败：

# cd /usr/local/log/ #进入目标路径

# touch mysql_error.log #创建mysql_error.log文件

# chown mysql.mysql mysql_error.log #给mysql_error.log文件赋权

完成后再启动数据库：[root@xa2305 ~]# ./bin/mysqld_safe --user="mysql"