CentOS6二进制安装mysql5.6多实例

最新推荐文章于 2022-01-17 18:10:38 发布

勿念旧梦

最新推荐文章于 2022-01-17 18:10:38 发布

阅读量364

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/wunianjiumeng/article/details/80166372

版权

MySQL 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

一、安装环境

OS: CentOS release 6.7 (Final)

mysql: mysql-5.6.40

basedir: /usr/local/mysql

datadir: /data/mysql3306/data

/data/mysql3307/data

my.cnf: /data/mysql3306/my.cnf

/data/mysql3307/my.cnf

二、环境准备

service  iptables  stop && chkconfig iptables off                
getenforce 0 && sed -i '/SELINUX/s/enforcing/disabled/' /etc/selinux/config
cd /opt/              ///文件压缩包上传至/opt/mysql 
tar -zxvf mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz
ln -s /opt/mysql-5.6.40-linux-glibc2.12-x86_64  /usr/local/mysql
rpm -e --nodeps `rpm -qa |grep mysql`
rpm -e --nodeps `rpm -qa |grep mysql-5.1`
groupadd mysql && useradd -M -g mysql -s /sbin/nologin -d /usr/local/mysql mysql
mkdir -p /data/{mysql3306,mysql3307}   //上传配置文件my.cnf
chown -R mysql:mysql /data/mysql330*/ /usr/local/mysql/

三、数据库初始化

/usr/local/mysql/scripts/mysql_install_db --defaults-file=/data/mysql3306/my.cnf --basedir=/usr/local/mysql --datadir=/data/mysql3306/data --user=mysql
/usr/local/mysql/scripts/mysql_install_db --defaults-file=/data/mysql3307/my.cnf --basedir=/usr/local/mysql --datadir=/data/mysql3307/data --user=mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
echo "PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH ">>/etc/profile && source /etc/profile

四、多实例启停及登录

[root@localhost ~] # /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysql3306/my.cnf &
[root@localhost ~] # mysql  -S /data/mysql3306/mysql3306.sock -uroot -p
[root@localhost ~]mysqladmin -S /data/mysql3306/mysql3306.sock -uroot -p shutdown

五、安全处理

mysql>use mysql;
mysql>update user set Password = password('root') where User='root';
mysql>select Host,User,Password  from user where User='root';
mysql> DELETE FROM mysql.user WHERE user='';
mysql>flush privileges;
mysql>exit