mysql5.7多实例安装
来源:互联网 发布:剑三萌萝莉脸型数据 编辑:程序博客网 时间:2024/06/05 05:26
cd /home/chenenhui
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.14-linux-glibc2.5-x86_64.tar
#rm -rf /usr/local/mysql*
cd /home/chenenhui
tar xf mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz -C /usr/local/
cd /usr/local/
ln -sv /usr/local/mysql-5.7.14-linux-glibc2.5-x86_64 mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin
cd /usr/local/mysql
useradd -r mysql
chown -R root.mysql ./
rm -rf /data/mysql3306*
mkdir -p /data/mysql3306/mysqldata
mkdir -p /data/mysql3306/logs
mkdir -p /data/mysql3306/binlog
mkdir -p /data/mysql3306/logs
mkdir -p /data/mysql3306/undo
cd /data
chown -R mysql.mysql ./
/usr/local/mysql/bin/mysqld --defaults-file=/etc/mysql/my3306.cnf --initialize-insecure --user=mysql
/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/mysql/my3306.cnf --user=mysql &
mysql -hlocalhost -uroot -p --socket=/data/mysql3306/logs/mysql.sock
UPDATE mysql.user SET authentication_string = PASSWORD('123456') WHERE USER LIKE '%root%';
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;
退出后可以 mysql -h127.0.0.1 -uroot -p -P3306
mkdri -p /data/mysql3307
rm -rf /data/mysql3307
mkdir -p /data/mysql3307/mysqldata
mkdir -p /data/mysql3307/logs
mkdir -p /data/mysql3307/binlog/
mkdir -p /data/mysql3307/logs/
mkdir -p /data/mysql3307/undo/
cd /data
chown -R mysql.mysql ./
/usr/local/mysql/bin/mysqld --defaults-file=/etc/mysql/my3307.cnf --initialize-insecure --user=mysql
/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/mysql/my3307.cnf --user=mysql &
mysql -hlocalhost -uroot -p --socket=/data/mysql3307/logs/mysql.sock
UPDATE mysql.user SET authentication_string = PASSWORD('123456') WHERE USER LIKE '%root%';
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;
退出后可以 mysql -h127.0.0.1 -uroot -p -P3307
# 关闭防火墙以便外界可以访问mysql
iptables -L -n -v
service iptables stop
getenforce
setenforce 0
iptables -L -n -v
service iptables save
history
0 1
- mysql5.7多实例安装
- mysql5.7多实例安装部署
- mysql5.5.49多实例安装
- mysql5.6多实例安装
- mysql5.7.17 多实例编译安装脚本
- mysql5.的编译安装单机多实例
- mysql5.6多实例
- linux安装mysql5.5多实例&&主从配置测试
- centos6.5 mysql5.6.24 单机多实例安装
- Windows下 安装Mysql5.7.16多个实例
- MySQL5.5源码安装----Cmake(多实例)
- 同一台服务器上安装mysql5.5和mysql5.7 不同版本的实例
- windows2008r2环境双实例安装mysql5.6
- Mysql5运行多个实例
- mysql5.6.10 多实例配置
- mysql5.5多实例部署
- mysql5.7.9启用多实例
- MySQL5.6多实例部署
- 语句include和require的区别
- JAVA中的String
- C# 日期格式化 补零
- Node.Js fs模块文件夹操作
- 数据处理可视化技术D3.JS--JavaScript常识
- mysql5.7多实例安装
- qt-qml移动开发之在ios上开发和部署app流程简介
- 数据结构实验之查找二:平衡二叉树
- QPalette~~控件颜色面板类QPalette
- 清除本地DNS
- Java知识点27
- vb敲机房的小问题
- Linux编译安装中configure、make和make install各自的作用
- HashSet剖析