mysql5.6安装

mysql安装

mysql5.6 （copy from 微策云linux版离线部署包cjdata-21-3-16.tar.gz）

mysql

mysql下载地址： https://downloads.mysql.com/archives/community/

参考：https://dev.mysql.com/doc/mysql-installation-excerpt/5.7/en/binary-installation.html

参考： https://dev.mysql.com/doc/mysql-installation-excerpt/5.7/en/data-directory-initialization.html

参考：https://developer.aliyun.com/article/503892

参考：mysql 5.6 多实例配置 https://developer.aliyun.com/article/52030

安装路径

sudo groupadd mysql
sudo useradd -r -g mysql -s /bin/false mysql

cd /cjdata/software/
sudo tar -zxvf mysql-5.6.51-linux-glibc2.12-x86_64.tar.gz
sudo mv mysql-5.6.51-linux-glibc2.12-x86_64 mysql_3307

cd mysql_3307
mkdir mysql-files
chown mysql:mysql mysql-files
chmod 750 mysql-files

创建一个my.cnf （也可以后面./scripts/mysql_install_db自动生成，然后再按需调整）

vim my.cnf

内容：

[mysql]

socket=/cjdata/software/mysql_3307/data/mysql.sock

[mysqld]
lower_case_table_names=1
# innodb_buffer_pool_size = 128Ms.
# log_bin
user= root
basedir = /cjdata/software/mysql_3307
datadir = /cjdata/software/mysql_3307/data
#log-error=/cjdata/software/mysql_3307/data/mysql.err
pid-file=/cjdata/software/mysql_3307/data/mysql.pid
socket=/cjdata/software/mysql_3307/data/mysql.sock
port = 3307
# server_id = .....
# socket = .....

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

主要是自定义sock文件，端口， base，data，log路径，sql_mode等

初始化mysql基础数据（这里下载的是5.6，所以执行的是下面5.6初始化命令）

# 5.7初始化（版本不对，不要执行下面这两句）
# sudo ./bin/mysqld --initialize-insecure --user=mysql --defaults-file=/cjdata/software/mysql_3307/my.cnf
# sudo bin/mysql_ssl_rsa_setup

# 5.6初始化权限表等mysql基础数据
sudo ./scripts/mysql_install_db --user=mysql --basedir=/cjdata/software/mysql_3307 --datadir=/cjdata/software/mysql_3307/data

启动

sudo ./bin/mysqld_safe --user=mysql &

开机启动

vim support-files/mysql.server

## 修改如下三行
basedir=/cjdata/software/mysql_3307
datadir=/cjdata/software/mysql_3307/data
lock_file_path="$lockdir/mysql_3307"


sudo cp support-files/mysql.server /etc/init.d/mysql_3307.server

# 复制改名启动脚本（从另一个微策云mysql5.6实例）
sudo cp /cjdata/vivachekcloud/bin/mysql_serverr mysql_3307.server

#修改路径
sudo vim mysql_3307.server

# 修改这里一行
APP_NAME=/cjdata/software/mysql_3307/support-files/mysql.server

root禁止远程登录并设置密码,

//查看有远程登录权限的用户（可以看到暂时都没有远程登录权限，差不多都是localhost）
select* from mysql.user;
//如果可以远程登录的记录，删除即可（未实验，注意备份）

//root 设置密码(与微策云离线部署数据库密码相同)
#UPDATE user SET Password = PASSWORD('新密码') WHERE user = 'root';
//允许root从公司ip登录(与微策云离线部署数据库密码相同)
grant all privileges on *.* to 'root'@'122.225.203.196' identified by '新密码' with grant option;

//允许test从公司ip登录（与微策云测试服test密码相同）
grant all privileges on *.* to 'test'@'122.225.203.196' identified by '新密码' with grant option;

flush privileges;

//todo 未完成

• root密码设置，只允许服务器登录。

• 增加test用户，只允许从公司地址登录。