一、安装依赖包
yum -y install make gcc-c++ cmake bison-devel ncurses-devel libaio libaio libaio-devel perl-Data-Dumper net-tools
二、创建用户
useradd mysql
passwd mysql
三、创建相关目录
mkdir -p /mofeng/{data,local,log,etc,package,src,tmp}
chmod 777 /mofeng/tmp
mkdir -p /mofeng/data/mysql/3306/{binlog,data,etc,pid,socket,tmp}
mkdir -p /mofeng/log/mysql
chown -R mysql:mysql /mofeng/data/mysql
四、解压源码包
tar zxvf mysql56.tar.gz -C /mofeng/local/
五、拷贝配置文件
mv my.cnf /mofeng/data/mysql/3306/etc/
六、初始化数据库
/mofeng/local/mysql56/scripts/mysql_install_db –defaults-file=/mofeng/data/mysql/3306/etc/my.cnf –basedir=/mofeng/local/mysql56 –datadir=/mofeng/data/mysql/3306/data –plugin-dir=/mofeng/local/mysql56/lib/plugin –user=mysql –log-error=/mofeng/log/mysql/mysql-error.log –open-files-limit=65535 –pid-file=/mofeng/data/mysql/3306/pid/mysql.pid –socket=/mofeng/data/mysql/3306/socket/mysql.sock –port=3306
七、启动数据库
cd /mofeng/local/mysql56
./bin/mysqld_safe –defaults-file=/mofeng/data/mysql/3306/etc/my.cnf &
八、修改数据库root用户密码
/mofeng/local/mysql56/bin/mysqladmin -u root password PASSWORD -S /mofeng/data/mysql/3306/socket/mysql.sock
九、登陆数据库
/mofeng/local/mysql56/bin/mysql -u root -p -S /mofeng/data/mysql/3306/socket/mysql.sock
十、关闭防火墙,修改selinux
1. Disable Firewalld Service.
systemctl mask firewalld
2. Stop Firewalld Service.
systemctl stop firewalld
十一、允许客户端登陆数据库
grant all on . to root@”%” identified by ‘NEW_PASSWORD’;
FLUSH PRIVILEGES;
十二、关闭数据库
/mofeng/local/mysql56/bin/mysqladmin shutdown -S /mofeng/data/mysql/3306/socket/mysql.sock -u root -p