Ubuntu 17.10安装mysql 5.7

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

评论0

请先
欢迎光临频率跳动资源网
显示验证码
没有账号?注册  忘记密码?