Warning: Use of undefined constant ‘classic_options’ - assumed '‘classic_options’' (this will throw an Error in a future version of PHP) in /www/wwwroot/blog.itisxx.com/wordpress/wp-content/themes/fullstack/single.php on line 4

Warning: Use of undefined constant ‘notice’ - assumed '‘notice’' (this will throw an Error in a future version of PHP) in /www/wwwroot/blog.itisxx.com/wordpress/wp-content/themes/fullstack/single.php on line 5
首页 > 技术 > Ubuntu 17.10安装mysql 5.7

Ubuntu 17.10安装mysql 5.7

技术 2017-11-4 16:08:57 19℃ 评论已关闭

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

 

 

上一篇: 下一篇:
请安装多说插件-下载地址