centos7安装mysql 8.0

centos7安装mySQL

安装

官网上下载：mysql80-community-release-el7-1.noarch.rpm

• 安装

rpm -ivh mysql80-community-release-el7-1.noarch.rpm 

yum -y install mysql-server 

• 配置/etc/my.cnf

vi /etc/my.cnf

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
server_id = 1
expire_logs_days = 3

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

• 启动mysqld服务

service mysqld start

• 登录（需要临时密码）

grep "password" /var/log/mysqld.log ##查看临时密码

mysql -u root -p ##使用临时密码登录

• 修改密码
  mysql 8.0与之前版本的修改密码方式不一致

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_na