Linux 下 MySQL-5.7版本安装

1、下载安装包

下载到/usr/local目录下

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz

2、解压

tar -zxvf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz

3、准备依赖包

apt-cache search libaio #search for info
apt-get install libaio1 # install library

4、安装并初始化

groupadd mysql
useradd -r -g mysql -s /bin/false mysql
cd /usr/local
tar -zxvf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz

ln -s /usr/local/mysql-5.7.35-linux-glibc2.12-x86_64 mysql;
cd mysql
mkdir mysql-files
chown mysql:mysql mysql-files
chmod 750 mysql-files
bin/mysqld --initialize --user=mysql
bin/mysql_ssl_rsa_setup
bin/mysqld_safe --user=mysql &
# NEXT command is optional
cp support-files/mysql.server /etc/init.d/mysql.server

5、登录

命令：

mysql -u root -p

提示：如果报错 command not found:mysql
执行：

ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql

6、修改密码

ALTER USER ‘root@'localhost' IDENTIFIED BY 'root'

创建root账号允许远程登陆，并授予所有权限。

CREATE USER 'root'@'%' INDENTIFIED BY 'root'
GRANT ALL ON *.* TO 'root'@'%';

7、退出

exit;

8、停止服务

mysql.server stop

9、创建配置文件

vim /etc/my.cnf

添加以下配置

[mysql]
prompt=(\\u@\\h)[\\d]>\\
[mysqld]
port = 3306
#datadir = /usr/local/mysql/data/
#log_error = error.log

10、防⽕墙配置

1、查看防⽕墙状态

sudo ufw status

2. 开启 3306 端⼝

 sudo ufw allow 3306

3、 阿⾥云配置安全组
https://developer.aliyun.com/article/767328?spm=a2c6h.13813017.0.dArticle738638.321121a44GCeEp