contos部署mysql8

yum install mysql yum install mysql-devel

wget dev.mysql.com/get/mysql80…

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

yum install mysql-community-server

No match for argument: mysql-community-server

Error: Unable to find a match: mysql-community-server

解决：

先执行：yum module disable mysql 

再执行：yum -y install mysql-community-server

service mysqld restart

登录mysql并输入密码

mysql -u root -p

mysql8 修改密码方式

alter user 'root'@'localhost' identified by '这里填你要的密码';

如果要授权的用户是新用户，而不是root账户，则要先新建用户；如果要授权的是root用户，则跳过此命令

CREATE USER '这里填你要新建的账户'@localhost IDENTIFIED BY '这里填要新建账户的密码';

授权，以root账户为例

GRANT ALL PRIVILEGES ON . TO 'root'@localhost WITH GRANT OPTION;

FLUSH PRIVILEGES;

创建成功