本文主要是介绍测试环境搭建整套大数据系统(十五:搭建mysql8),希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
一:更新系统
$sudo apt update
$sudo apt list --upgradable# get a list of upgrades
$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 'password' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;
/etc/mysql/my.cnf 配置文件
bind-address=0.0.0.0
这篇关于测试环境搭建整套大数据系统(十五:搭建mysql8)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!