1.安装数据库
apt-get install mysql-server mysql-client
检查是否在运行
sudo netstat -tap | grep mysql
如果没启动,手工启动:
/etc/init.d/mysql restart
2.设置root密码
mysql -u root
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
exit;
测试登录
mysql -u root -p
修改为可远程登录
修改root账号的主机地址为%,以便远程连接;
mysql -u root -p
USE mysql;
update user set host =’%’ where User =‘root’;
flush privileges;
解决ubuntu下mysql无法远程连接问题(10060/10061)
关闭防火墙或配置防火墙允许3306 端口
ufw disable (关闭防火墙)
修改/etc/mysql/mysql.conf.d/mysqld.cnf或/etc/mysql/my.conf路径下的bind-address参数
将其中的bind-address=127.0.0.1改为bind-address=0.0.0.0,再重启mysql服务/etc/init.d/mysql restart