linux安装mysql 5.7.23 - artinfo1982/demos GitHub Wiki

1.在mysql官网下载mysql-5.7.23.tar.gz，上传到linux服务器的任意路径，比如/opt下，解压 2.重命名

mv /opt/mysql-5.7.23-xxx /opt/mysql

3.创建数据目录

mkdir /opt/mysql-data

4.创建mysql组、用户

groupadd mysql
useradd -r -s /sbin/nologin -g mysql mysql -d /opt/mysql
chown -R mysql.mysql /opt/mysql
chown -R mysql.mysql /opt/mysql-data

5.初始化mysql

/opt/mysql/bin/mysqld --initialize --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql-data

6.编辑/etc/my.cnf

[mysqld]
port=3306
user=mysql
basedir=/opt/mysql
datadir=/opt/mysql-data
tmpdir=/tmp
socket=/tmp/mysql.sock
lower_case_table_names=1
character-set-server=utf8
log-error=/opt/mysql-data/log/mysqld.log
symbolic-links=0
pid-file=/opt/mysql-data/pid/mysqld.pid
[mysql]
default-character-set=utf8

7.修改root用户localhost权限以及设置密码

/opt/mysql/bin/mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
/opt/mysql/bin/mysql -u root
mysql> set global read_only=0;
mysql> flush privileges;
mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'Huawei123' with grant option;
mysql> flush privileges;
mysql> set global read_only=1;
mysql> flush privileges;
mysql> quit

8.杀掉mysqld_safe进程 9.后台启动mysqld

nohup /opt/mysql/bin/mysqld > /dev/null &

10.创建用户、表空间、赋权限

/opt/mysql/bin/mysql -u root -p
mysql> create user 'cd'@'%' identified by 'huawei';
mysql> create database if not exists cddb default charset utf8 collate utf8_general_ci;
mysql> grant all privileges on `cddb`.* to 'cd'@'%' identified by 'huawei';
mysql> flush privileges;
mysql> quit