centos7.0 安装 MySql8.0

1 清理环境

1.1 查看是否有 mysql 数据库

$ rpm -qa | grep mysql

1.2 有 mysql 数据库

$ yum remove mysql-xxx-xxx #卸载mysql
$ find / -name mysql #查找mysql配置文件
$ rm -rf /var/lib/mysql #删除配置文件

1.3 删除 MariaDB 的文件

$ rpm -qa | grep mariadb #寻找MariaDB
$ yum -y remove mariadb-libs.x86_64 #卸载MariaDB

2 安装 MySql

2.1 下载 yum 源安装包

wget https://repo.mysql.com/mysql80-community-release-el8-4.noarch.rpm
yum localinstall mysql80-community-release-el8-4.noarch.rpm
 
yum repolist enabled
 
# yum install https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

禁用 centos8.0 自带的 mysql 模块

yum module disable mysql

2.2 安装 mysql

$ yum install mysql-community-server

2.2.1 问题 1

Error: Unable to find a match: mysql-community-server
$ yum module disable mysql #禁用本地的MySQL模块,再安装。

2.2.2 问题 2

参考 https://blog.csdn.net/lcyaiym/article/details/77282336

Error: GPG check FAILED
$ vi /etc/yum.repos.d/mysql-community.repo #设置gpgcheck=0

2.3 初始化 MySql

$ mysqld --initialize

2.4 启动 MySql

$ service mysqld start
$ service mysqld status #查看状态
$ grep 'temporary password' /var/log/mysqld.log #查看初始密码

2.5 登录

$ mysql -uroot -p

2.6 更改密码

$ alter user 'root'@'localhost' identified by 'xxxxx';

2.7 创建远程访问用户，依次执行下列命令

$ create user 'root'@'%' identified with mysql_native_password by 'xxxxx';
$ grant all privileges on *.* to 'root'@'%' with grant option;
$ flush privileges;

3.0 其他命令

$ systemctl start mysqld  #启动mysqld
$ systemctl stop mysqld  #停止mysqld
$ systemctl restart mysqld  #重启mysqld
$ systemctl enable mysqld  #设置开机启动
$ mysqladmin --version  #验证MySql安装

Ubuntu 安装 MySql

apt install mysql-server
sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by '你的密码';
 
mysql_secure_installation
 
mysql -uroot -p
use mysql;
select user,host from user;
CREATE USER 'root'@'%' IDENTIFIED BY '你的密码';
 
GRANT ALL ON *.* TO 'root'@'%';
 grant all privileges on *.* to 'root'@'%' with grant option;
 
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'awsd123321@A.';
 
flush privileges;

UPDATE user SET host = 'localhost' WHERE user ='root';