安装环境:
系统:Cento7.4
Mysql版本:8.0.11
Mysql远程连接工具:Navicat
一 创建Mysql账户
groupadd mysql
useradd -g mysql mysql
二 准备安装包
mysql-community-common-8.0.11-1.el7.x86_64.rpm
mysql-community-libs-8.0.11-1.el7.x86_64.rpm
mysql-community-client-8.0.11-1.el7.x86_64.rpm
mysql-community-server-8.0.11-1.el7.x86_64.rpm
下载地址:链接:https://pan.baidu.com/s/1FbpAbpbu0IY0z3LMHHa9Zw 密码:eut2
三 安装Mysql
安装之前需要检测系统是否有安装mysql
rpm -qa | grep mysql
rpm -qa | grep mariadb
如果有使用命令进行卸载
rpm -e --nodeps XXX
卸载完成之后按照下列顺序进行安装
rpm -ivh mysql-community-common-8.0.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.11-1.el7.x86_64.rpm
报错1
error: Failed dependencies: /usr/bin/perl is needed by
mysql-community-server-8.0.11-1.el7.x86_64 perl(Getopt::Long) is
needed by mysql-community-server-8.0.11-1.el7.x86_64 perl(strict)
解决1
yum install perl
报错2
error: Failed dependencies:
libaio.so.1()(64bit) is needed by mysql-community-server-8.0.11-1.el7.x86_64
libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-8.0.11-1.el7.x86_64
解决2
wget http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm
rpm -ivh http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm
四 初始mysqld –initialize启动数据库
systemctl start mysqld
六 查看初始化密码
vim /var/log/mysqld.log
;%WTMdmz0b#a
七 链接Mysql
mysql -uroot -p
密码为上一步找到的初始化密码
八 重置密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'a123456';
九 开启远程连接权限
CREATE USER 'admin'@'%' IDENTIFIED BY 'a123456';
grant all on *.* to 'admin'@'%';
flush PRIVILEGES;
十 连接报错
因为mysql8.0改变了加密方式,使用下面的命令即可解决问题
ALTER USER 'admin'@'%' IDENTIFIED BY 'a123456' PASSWORD EXPIRE NEVER;
ALTER USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'a123456';
FLUSH PRIVILEGES;
作者:p_oldpai
来源:CSDN
原文:https://blog.csdn.net/cjh365047871/article/details/80444987
版权声明:本文为博主原创文章,转载请附上博文链接!