阿里云服务器安装mysql5.7命令

#mysql官网下载压缩包
https://dev.mysql.com/downloads

1、查看mariadb是否存在有则卸载（安装mysql时会有冲突）
#查看是否存在

rpm -qa | grep mariadb
mariadb-libs-5.5.60-1.el7_5.x86_64

#有则卸载

rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps

2、cd usr/server进入server目录下，新建mysql文件

mkdir mysql

2-1、进入文件夹

cd mysql

3、解压压缩包到
tar -zxvf mysql压缩包文件

tar -zxvf mysql5.7.34.tar.gz

##解压压缩包到 mysql目录##
##tar -zxvf 压缩包 -C mysql##

4、切换到安装目录安装依赖

cd mysql
yum -y install libaio
yum -y install libncurses*
yum -y install perl-devel

5、安装mysql服务器 仔细查看mysql版本

rpm -ivh mysql-community-common-5 .7.34-1.e17.x86_64.rpm
rpm -ivh mysql-community-libs-5 .7 .34-1.e17.x86_64.rpm
rpm -ivh mysql-community-client-5.7.34-1.e17 .x86_64.rpm
rpm -ivh mysql-community-server-5 .7.34-1.e17.x86_64.rpm

6、启动mysql

systemctl start mysqld.service

7、查看生成的临时root密码

cat /var/1og/mysqld.log I grep password

8、更新root密码设置为root 关闭密码验证英文大小超过8位

set global validate_password_policy=0;
set global validate_password_length=1;
set password=password('root');

9、登录

mysql -u root -p

10、设置外网可以连接

use mysql;
select host,user from user;
update user set host = '%' where user = 'root';
flush privileges;

11、mysql的启动和关闭 状态查看

systemctl start mysqld
systemctl stop mysqld
systemctl status mysqld

建议设置为开机自启动服务

systemctl enable mysqld

查看是否已经设置自启动成功

systemctl list-unit-files l grep mysqld

不区分大小写-配置文件写入

vim /etc/my.cnf
lower_case_table_names=1