MySQL二进制安装

下载地址:https://dev.mysql.com/downloads/mysql/

#创建用户
adduser -r -s /usr/sbin/nologin mysql
#解压
tar zxvf mysql-5.7.36-linux-glibc2.12-x86_64.tar.gz  -C /usr/local/

# 创建软链接
ln -sv mysql-5.7.36-linux-glibc2.12-x86_64/ mysql

# 创建文件夹
cd /usr/local/mysql
mkdir binlog
mkdir data
mkdir mysqltmp
touch mysql_run.err

# 创建配置
vim /usr/local/mysql/my.cnf

my.cnf 配置

[client]
port = 33061
socket=/usr/local/mysql/mysql.sock

[mysql]
port = 33061
default-character-set=utf8
socket=/usr/local/mysql/mysql.sock

[mysqld]
skip-name-resolve
port = 33061
socket=/usr/local/mysql/mysql.sock
tmpdir=/usr/local/mysql/mysqltmp
basedir=/usr/local/mysql
log-error = /usr/local/mysql/mysql_run.err
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
lower_case_table_names=0
max_allowed_packet=16M
log-bin =/usr/local/mysql/binlog/mysql-bin
binlog_format="MIXED"
expire_logs_days = 7
binlog_cache_size = 8M
max_binlog_cache_size = 512M
max_binlog_size = 1G
sync_binlog = 1000
skip-name-resolve
server-id = 1
sync-binlog=1

# 给权限
chown -R mysql.mysql mysql-5.7.36-linux-glibc2.12-x86_64/
chown -R mysql.mysql mysql/
# 初始化 记得查看输出的密码
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
# 按实际情况修改启动脚本(主要basedir、datadir)
vim ./support-files/mysql.server
# 启动
./support-files/mysql.server start
# 停止
./support-files/mysql.server stop
# 连接
./bin/mysql -uroot -p --socket=/usr/local/mysql/mysql.sock

# 设置密码
set password for root@localhost = password('shapolang');
# 刷新权限
flush privileges;