MySQL8.0 各种平台安装

标签（空格分隔）： MySQL系列

---

一：CentOS7.9 安装MySQL8.0

下载国内源
wget http://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql80-community-release-el7-1.noarch.rpm

yum install -y mysql-server --nogpgcheck  安装 MySQL8.0

service mysqld start  启动MySQL8.0

chkconfig mysqld on  开机启动MySQL8.0

vim /etc/my.conf
---
[mysqld]
validate_password.policy=0
validate_password.length=1
----
service mysqld restart 

cd /var/log/

cat mysqld.log |grep password  [给出MySQL默认密码登录]

mysql -uroot -p 

set password = 'flyfish225';

set password = '[e-mail]';

use mysql;

### 初始化yum 安装mysql8.0不能使用下面命令
update user set authentication_string='flyfish225' where user='root';

update user set authentication_string='[e-mail]' where user='root';

set password for "root"@"localhost"=password("flyfish225");

flush privileges;

----

exit 

mysql -uroot -pflyfish225 

use mysql;

update user set host = '%' where user = 'root';（设置root任意地址访问）

select host, user, authentication_string, plugin from user;  查看连接

select user,host from mysql.user;

flush privileges;


exit 

---

mysql -uroot -pflyfish225 

ALTER USER 'root'@'%' IDENTIFIED BY 'flyfish225' PASSWORD EXPIRE NEVER;

ALTER USER 'root'@'%' IDENTIFIED BY '[e-mail]' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '[e-mail]';


flush privileges;


下面远程natvcat 就可以登录了

----------

普通用户登录：

create database hive;
create user 'hive'@'%' identified by 'hive';
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%' WITH GRANT OPTION;
update user set host = '%' where user = 'hive';


grant system_user on *.* to 'root';

ALTER USER 'hive'@'%' IDENTIFIED BY 'hive' PASSWORD EXPIRE NEVER;
ALTER USER 'hive'@'%' IDENTIFIED WITH mysql_native_password BY 'hive';

flush privileges;

下面普通用户hive 就可以natvcat 远程登录了

二：Ubuntu20.04 安装MySQL8.0

安装MySQL8.0 

apt-get install mysql-server 

service mysql start 

vim /etc/mysql/mysql.conf.d/mysqld.cnf

注释掉下面两行
----
#bind-address           = 127.0.0.1
#mysqlx-bind-address    = 127.0.0.1
----

service mysql restart 

mysql ---> 进入MySQL


create user 'root'@'%' identified by 'root';
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
ALTER USER 'root'@'%' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';

grant system_user on *.* to 'root';

flush privileges;


普通用户远程登录
create user 'hive'@'%' identified by 'hive';
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%' WITH GRANT OPTION;
ALTER USER 'hive'@'%' IDENTIFIED BY 'hive' PASSWORD EXPIRE NEVER;
ALTER USER 'hive'@'%' IDENTIFIED WITH mysql_native_password BY 'hive';
flush privileges;