unbtun系统在线安装MySQL

依次执行三行命令:

sudo apt-get install mysql-server

sudo apt-get install mysql-client

sudo apt-get install libmysqlclient-dev

检查是否安装成功

sudo netstat -tap | grep mysql

查看当前默认用户密码

cd /etc/mysql
// 查看文件
sudo cat debian.cnf

得到如下结果

[client]
host     = localhost
user     = debian-sys-maint
password = xxxxx
socket   = /var/run/mysqld/mysqld.sock

登录MySQL

// 填写你的信息
mysql -udebian-sys-maint -pxxxxx

新建用户

// '%'代表所有主机可以访问
CREATE USER 'test'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

修改配置文件

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

找到

bind-address = 127.0.0.1 
改为:
#bind-address = 127.0.0.1

重启MySQL并打开防火墙3306端口

service mysql restart
sudo ufw allow 3306 

大功告成!