centos7.6安装mysql

1.下载yum安装镜像

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

安装

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

2.开启服务

service mysqld start

3.查看初始密码

grep 'temporary password' /var/log/mysqld.log

4.登录

mysql -u root -p

修改密码强度

SHOW VARIABLES LIKE 'validate_password%';
set global validate_password.policy=LOW; 

修改密码

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

5.开启远程登陆

use mysql;
update user set host = '%' where user = 'root';
GRANT ALL ON *.* TO 'root'@'%';
flush privileges;
重启MySQL。

数据目录：/usr/lib/mysql
配置文件：/etc/my.cnf
日志：/var/log/mysqld.log
PID文件：/var/run/mysqld
sock：/var/lib/mysql/mysql.sock