源码安装mysql

下载

https://dev.mysql.com/downloads/mysql/

安装前

[root@localhost src]# groupadd -r mysql

[root@localhost src]# useradd -r -g mysql -s /sbin/nologin -M mysql

[root@localhost src]# mkdir -p /opt/mysql

[root@localhost src]# mkdir -p /opt/data

[root@localhost src]# chown mysql:mysql -R /opt/mysql/

[root@localhost src]# chown mysql:mysql -R /opt/data/

[root@localhost src]# mkdir -p /opt/software

[root@localhost src]# cd /opt/software/

[root@localhost software]# ls

mysql-5.6.44  mysql-5.6.44.tar.gz

[root@localhost software]# tar -zxvf mysql-5.6.44.tar.gz

安装

cmake . -DCMAKE_INSTALL_PREFIX=/opt/mysql \

-DMYSQL_DATADIR=/opt/data \

-DSYSCONFDIR=/etc \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_ARCHIVE_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DWITH_SSL=system \

-DWITH_ZLIB=system \

-DWITH_LIBWRAP=0 \

-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci

[root@localhost mysql-5.6.44]# make clean

[root@localhost mysql-5.6.44]#  rm CMakeCache.txt

rm: remove regular file `CMakeCache.txt'? y

[root@localhost mysql-5.6.44]#

[root@localhost mysql-5.6.44]# make && make install && echo OK

这个时间会很长

配置

[root@localhost mysql-5.6.44]# cp support-files/my-default.cnf /etc/my.cnf

允许远程使用root链接数据库

mysql> Grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)