第一步:ubuntu安装mysql-server
sudo apt-get install mysql-server
第二步:配置服务器,这一步很重要
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
- bind-address = 127.0.0.1
+ # bind-address = 127.0.0.1
第三步:服务端命令行登录mysql
mysql -h 127.0.0.1 -u root -p
show databases;
use mysql;
show tables;
第四步:设置远程连接权限
select host,user form user;
update user set host='%' where user='root';
grant all privileges on *.* to 'root'@'%' identified by '你的root账户密码';
flush privileges;
第五步:关闭防火墙
sudo ufw disable
第六步:重启mysql服务
service mysql stop
service mysql start