测试环境搭建整套大数据系统（十五：搭建mysql8）

一：更新系统

$sudo apt update
$sudo apt list --upgradable
$sudo apt upgrade

二：下载

sudo apt install mysql-server-8.0
sudo mysql

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ysh@123';
exit

设置开机自启动

sudo systemctl is-enabled mysql.service

三：设置远程访问

ALTER USER 'root'@'localhost' IDENTIFIED BY 'ysh@123' PASSWORD EXPIRE NEVER; 
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'ysh@123';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

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

bind-address=0.0.0.0