sudo apt-get install mysql-server
mysql -u root -p
show databases;
use mysql;
show tanles;
select * from user;
update user set Host=’%’ where User=’root’;
GRANT ALL PRIVILEGES ON 数据库.* TO 用户名@”%” IDENTIFIED BY “用户密码”;
flush privileges;
exit;
sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address=127.0.0.1 改为 bind-address=0.0.0.0
sudo ufw allow 3306 防火墙开放3306端口
sudo /etc/init.d/mysql restart 重启mysql
http://blog.csdn.net/paincupid/article/details/76039532
原文链接:https://www.hertzdance.com/blog/ubuntu-17-10-mysql-5-7,转载请注明出处。
评论0