install_mysql_567(客户端)_安装

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;