Mysql二进制安装

# 创建用户
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
# 创建数据目录
mkdir -p /data/mysql3306/{mysql,binlog,slowlog,tmp,log,run}
mkdir -p /usr/local/mysql
chown -R mysql. /data/mysql3306
chown -R mysql. /usr/local/mysql

dir=`pwd`
cd $dir
yum install -y wget && wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
tar zxf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz -C /usr/local/src
cp -r /usr/local/src/mysql-5.7.26-linux-glibc2.12-x86_64/* /usr/local/mysql

# 配置环境变量
echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile
# 初始化
mysqld --defaults-file=/data/mysql3306/config/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql3306/mysql
# 配置ssl
mysql_ssl_rsa_setup --basedir=/usr/local/mysql --datadir=/data/mysql3306/mysql
# 手动启动
mysqld_safe --defaults-file=/data/mysql3307/config/my.cnf &

cp mysqld.service /usr/lib/systemd/system/mysqld.service
systemctl enable mysqld
systemctl start mysqld

more error.log | grep password
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Paswword1!';
flush privileges

# 初始化
mysqld --defaults-file=/data/mysql3307/config/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql3307/mysql
mysql_ssl_rsa_setup --basedir=/usr/local/mysql --datadir=/data/mysql3307/mysql
mysqld --defaults-file=/data/mysql3307/config/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql3307/mysql
mysql_ssl_rsa_setup --basedir=/usr/local/mysql --datadir=/data/mysql3307/mysql
# 启动
cp mysqld.service /usr/lib/systemd/system/mysqld3306.service
cp mysqld.service /usr/lib/systemd/system/mysqld3307.service
# 修改mysqld.service启动文件
Type=forking 改为 Type=sample
ExecStart启动命令改为/usr/local/bin/mysqld --defaults-file=/data/mysql3306/config/my.cnf
# 启动mysql
systemctl enable mysqld3306
systemctl start mysqld3306

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
#设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=E:\downland\mysql-5.7.26-winx64
# 设置mysql数据库的数据的存放目录
datadir=E:\downland\mysql-5.7.26-winx64/data
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB

mysqld --install
mysqld --initialize-insecure
net start mysql
sc query mysql