ubuntu16.04 安装mysql5.7并设置root远程访
作者:
WJXZ | 来源:发表于
2018-07-21 12:51 被阅读0次1.安装mysql5.7
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install libmysqlclient-dev
2.修改配置文件
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
# bind-address = 127.0.0.1
3.进入mysql命令行执行sql语句
mysql -u root -p
#回车后输入密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
4.重启mysql服务
service mysql restart
本文标题:ubuntu16.04 安装mysql5.7并设置root远程访
本文链接:https://www.haomeiwen.com/subject/wvlhmftx.html
网友评论