编译安装mysql

编译安装MYSQL

1.下载所需MYSQL包
2.安装epel源
wget -O /etc/yum.repos.d/epel.repo https://mirrors.aliyun.com/repo/epel-6.repo
3.安装依赖包
yum install -y ncurses-devel libaio-devel make autoconf automake curl curl-devel gcc gcc-c++ gtk±devel zlib-devel openssl openssl-devel pcre-devel perl kernel-headers compat* cpp glibc libgomp libstdc+±devel keyutils-libs-devel libsepol-devel libselinux-devel krb5-devel libXpm* freetype freetype-devel freetype* fontconfig fontconfig-devel libpng* ncurses* libtool* libxml2-devel bison libaio-devel cmake
4.创建用户
useradd mysql -s /sbin/nologin -M
5.修改hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.195.132 bogon
6.解压MYSQL包
[root@bogon ~]# tar -xf mysql-5.6.36.tar.gz
7.进入目录
[root@bogon ~]# cd mysql-5.6.36/
8.创建目录
mkdir /application/mysql-5.6.36 -p
9.生成文件
cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.6.36
-DMYSQL_DATADIR=/application/mysql-5.6.36/data
-DMYSQL_UNIX_ADDR=/application/mysql-5.6.36/tmp/mysql.sock
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DWITH_EXTRA_CHARSETS=all
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_FEDERATED_STORAGE_ENGINE=1
-DWITH_BLACKHOLE_STORAGE_ENGINE=1
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1
-DWITH_ZLIB=bundled
-DWITH_SSL=bundled
-DENABLED_LOCAL_INFILE=1
-DWITH_EMBEDDED_SERVER=1
-DENABLE_DOWNLOADS=1
-DWITH_DEBUG=0
10.编译
make
11.安装
make install
12.软链接
ln -s /application/mysql-5.6.36/ /application/mysql
13.拷贝配置文件
cp support-files/my*.cnf /etc/my.cnf
14.拷贝mysql启动脚本
cp support-files/mysql.server /etc/init.d/mysqld
创建目录
mkdir /application/mysql-5.6.36/tmp
15.进入mysql初始化脚本目录
cd /application/mysql/scripts/
16.初始化mysql
./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data --user=mysql
17.授权
chown -R mysql.mysql /application/mysql/
18.给启动脚本授权
chmod 700 /etc/init.d/mysqld
19.systemd管理mysql启动
vim /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=https://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=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
20.设置开机自启动
chkconfig mysqld on
systemctl enable mysqld
/etc/init.d/mysqld start
systemctl start mysqld
21.添加环境变量
echo ‘PATH=/application/mysql/bin/:$PATH’ >/etc/profile.d/mysql.sh
source /etc/profile.d/mysql.sh
22.设置MYSQL密码
mysqladmin -uroot password ‘123’
23.MYSQL登录
mysql -uroot -p123