MYSQL 8.013安装

1. 安装

指定目录

mkdir /usr/local/mysql
cd /usr/local/mysql

下载安装包

wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

执行安装

yum -y install mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql-community-server

设置不区分大小写

修改 /etc/my.cnf，mysqld下添加(!!!服务启动前)

lower_case_table_names = 1

2. 启动\查看

启动

systemctl start  mysqld.service

查看

systemctl status mysqld.service

3. 登陆

获取临时密码

grep "password" /var/log/mysqld.log

使用默认密码登陆

mysql -uroot -p（默认密码）

修改密码规则

set global validate_password.policy=0;
set global validate_password.length=6;

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root@123456';

创建用户

CREATE USER 'admin'@'%' IDENTIFIED BY '123456';

授权远程访问

GRANT ALL ON *.* TO 'admin'@'%';

查看自启动

systemctl list-unit-files|grep enabled