1.文件到/data/package/下
mkdir -p /data/packages/
mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz
my56.cnf
2.删除自带的mysql
rpm -qa |grep mysql
rpm -e mysql-devel-5.1.73-7.el6.x86_64 --nodeps
rpm -e mysql-5.1.73-7.el6.x86_64 --nodeps
rpm -e mysql-libs-5.1.61-4.el6.x86_64 --nodeps
3.安装
yum -y install cmake make gcc gcc-c++ gd-devel ncurses-devel libaio libaio-devel bison autoconf curl-devel mlocate readline-devel readline flex
cd /data/packages/
tar -zxf mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz -C /usr/local/
cd /usr/local/
ln -s mysql-5.6.34-linux-glibc2.5-x86_64 mysql
rm -rf mysql/data
--修改下 server_id
mv /data/packages/my56.cnf /etc/my.cnf
mkdir -p /data/mysql/{data,log,tmp}
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
chown -R mysql:mysql /data/mysql/data /data/mysql/log /data/mysql/tmp
chown -R mysql:mysql /usr/local/mysql-5.6.34-linux-glibc2.5-x86_64
chown mysql:root /etc/my.cnf
chmod 640 /etc/my.cnf
ln -s /data/mysql/data /usr/local/mysql/data
ln -s /data/mysql/log /usr/local/mysql/log
ln -s /data/mysql/tmp /usr/local/mysql/tmp
vim ~/.bash_profile
末行添加:
export PATH=$PATH:/usr/local/mysql/bin
source ~/.bash_profile
4.初始化
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --defaults-file=/etc/my.cnf --user=mysql
5.启动
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
service mysqld start
chkconfig --add mysqld
6.进入mysql并删除多余的用户并创建新用户
mysql
delete from mysql.user where user!='root';
grant reload,process,lock tables,super,select,event,replication client,replication slave on *.* to 'slave-repl'@'10.6.%' identified by '8BhHY0vK7Al4btd';
update mysql.user set password=password('mjeY155vQdEE30rU2jhj') where user = 'root';
flush privileges;