1.修改MySQL的配置文件(windows是my.ini, linux是 my.cn.cnf或my.cnf),如果有bind-address这一行,值改为0.0.0.0,这样可以允许任意IP地址连接到MySQL服务器。
bind-address = 0.0.0.0
没有bind-address, 就补上bind-address = 0.0.0.0这一行
2.修改权限
grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
flush privileges;
或者修改mysql库里面的user表, 把host改成%, 然后再刷新权限.
==================================================================
ubuntu安装mysql
sudo apt update
sudo apt-get install mysql-server
mysql安装好后, mysql配置为 /etc/mysql/mysql.conf.d
先修改权限可以写, sudo chmod 777 /etc/mysql/mysql.conf.d
再把权限改回只有root可以读写, 其它只读sudo chmod 644 /etc/mysql/mysql.conf.d
=========================================
启动服务:
service mysql start
查看状态:
service mysql status
停止服务:
service mysql stop
重启服务:
service mysql restart
=======================================
mysql备份数据用mysqldump,还原是用mysql, 不是mysqldump了
--备份
mysqldump -h192.168.1.100 -uroot -p123 testDB > backup.sql
--还原
mysql -h192.168.1.100 -uroot -p123 testDB < backup.sql
标签:其它,service,0.0,mysql,bind,conf,address,连接 From: https://www.cnblogs.com/barrysgy/p/18202919