Ubuntu16.0.4安装mysql
十分简单,按顺序敲下面的命令就好
安装
sudo apt-get install mysql-server
sudo apt isntall mysql-client
sudo apt install libmysqlclient-dev
查看服务状态
sudo netstat -tap | grep mysql
修改配置
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉bind-address = 127.0.0.1:
允许远程登陆,这里需要登陆mysql mysql -uroot -p登陆本地
grant all on *.* to [email protected]'%' identified by '你的密码' with grant option;
刷新权限
flush privileges;
退出MySQL(exit命令即可),重启服务
service mysql restart
本地使用navicate客户端连接远程数据库