rhel6源码安装mysql_RHEL6 源码安装mysql-5.7.27

yum -y install gcc make cmake ncurses-devellibxml2-devel libtool-ltdl-devel gcc-c++ autoconf automake bison zlib-devel

yum-y install cmake bison git ncurses-devel gcc gcc-c++

yuminstall -y cmake bison bison-devel libaio-devel gcc gcc-c++ git  ncurses-devel

yum -y install ncurses ncurses-devel bison cmake

yum install -y gcc gcc-c++

wgethttps://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.27.tar.gz#mysql5.7源码安装需要boost，这个包自动下载boost

mv boost_1_59_0.tar.gz  /usr/src/mysql-5.7.27 (如果不执行此句,在cmake时会自动下载boost)

mkdir -p /weblogic/mysql/mysql

mkdir -p /weblogic/mysql/datadir

[root@ftpserver ~]#  groupadd mysql

[root@ftpserver ~]#  useradd -r -s /sbin/nologin -g mysql mysql

[root@ftpserver ~]# tar -zxfmysql-5.7.27.tar.gz -C /usr/src

[root@ftpserver ~]# cd /usr/src/mysql-5.7.27/

以下整段为配置的命令

cmake . -DCMAKE_INSTALL_PREFIX=/weblogic/mysql/mysql-DMYSQL_DATADIR=/weblogic/mysql/datadir -DDOWNLOAD_BOOST=1-DWITH_BOOST=/my/mysql-5.7.27/boost -DSYSCONFDIR=/etc-DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1-DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1-DWITH_MYISAM_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DENABLE_DTRACE=0-DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

make

make install

修改/etc/my.cnf

[mysqld]

user=mysql

basedir=/weblogic/mysql/mysql

datadir=/data/mysql

pid-file=/usr/local/mysql/mysql.pid

socket=/usr/local/mysql/mysql.sock

explicit_defaults_for_timestamp=true

[mysqld_safe]

log-error=/usr/local/mysql/logs/mysqld.log

pid-file=/usr/local/mysql/pids/mysqld.pid

# Disabling symbolic-links is recommended to prevent assorted securityrisks

symbolic-links=0

# Settings user and group are ignored when systemd is used.

# If you need to run mysqld under a different user or group,

# customize your systemd unit file for mariadb according to the

# instructions in http://fedoraproject.org/wiki/Systemd

[client]

default-character-set=utf8

socket=/usr/local/mysql/mysql.sock

[mysql]

default-character-set=utf8

socket=/usr/local/mysql/mysql.sock

创建配置文件中用到的而你系统中没有的目录

mkdir -p /data/mysql

mkdir -p /usr/local/mysql/logs/

mkdir -p /usr/local/mysql/pids/

[root@master mysql]# chown -R mysql:mysql /usr/local/mysql/

[root@master mysql]# chmod -R 777 /usr/local/mysql/

[root@master mysql]# chown -R mysql:mysql /data/mysql/

[root@master mysql]# chmod -R 777 /data/mysql/

[root@ftpserver logs]# touch /usr/local/mysql/logs/mysqld.log

chown -R mysql:mysql /usr/local/mysql

初始化mysql

[root@ftpserver bin]# pwd

/weblogic/mysql/mysql/bin

./mysqld --initialize --user=mysql --basedir=/weblogic/mysql/mysql--datadir=/data/mysql

这一步执行完mysql会给出一个默认密码，需要记住

如果初始化有误，可以直接把mysql目录下的data整个删除，然后重新初始化

cd /data/mysql

rm –f *

把mysql.server复制到服务列表，并添加执行权限，方便管理

[root@master support-files]# cp /weblogic/mysql/mysql/support-files/mysql.server  /etc/init.d/mysqld

[root@master support-files]# chmod +x /etc/init.d/mysqld

把mysql的bin目录添加到环境变量，方便使用

export PATH=/weblogic/mysql/mysql/bin:$PATH添加到/etc/profile最后一行，并且启用

source /etc/profile

(也可以这么写:

PATH=/weblogic/mysql/mysql/bin:$PATH

echo “export PATH=/weblogic/mysql/mysql/bin:$PATH” >>/etc/profile

source /etc/profile

)

[root@master ~]# chkconfig --add mysqld

[root@master ~]# chkconfig mysqld on

[root@ftpserver mysql]# touch /usr/local/mysql/mysql.sock

[root@ftpserver mysql]# chmod -R 777 /usr/local/mysql/mysql.sock

[root@ftpserver mysql]# touch /usr/local/mysql/mysql.pid

[root@ftpserver mysql]# chmod -R 777 /usr/local/mysql/mysql.pid

启动服务

serivce mysqld start

安全固化脚本

./weblogic/mysql/mysql/bin/mysql_secure_installation

修改密码

mysql -uroot -p你的原始密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'oracle';

Query OK, 0 rows affected (0.00 sec)

mysql> exit

Bye

[root@master init.d]# mysql -u root -poracle

登录后，开启数据库远程访问权限

mysql> grant all privileges on *.* to root@'%' identified by "oracle";

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

之后就可以随便用了