mysql部署
更新 apt 列表
apt-get upgrade
安装 mysql
apt-get install mysql-server
启动数据库
# 启动:
service mysql start
# 重启:
service mysql restart
# 关闭:
service mysql stop
查看默认用户密码
cat /etc/mysql/debian.cnf
用上述账号登录
mysql -h 127.0.0.1 -udebian-sys-maint -p
修改root用户密码
alter user 'root'@'%' identified with mysql_native_password by 'Password123!';
修改访问权限
vi /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address = 0.0.0.0
重启数据库
service mysql restart