记笔记!!!
授权远程连接本数据库:
net start mysql
mysql -uroot -p
use mysql
update user set host=’%’ where user=‘root’;
select host,user from user;
flush privileges;
通过ip地址远程连接数据库:
mysql -h 192.168.xx.xx -u root -p
查看ip:在cmd 中 ipconfig
记笔记!!!
授权远程连接本数据库:
net start mysql
mysql -uroot -p
use mysql
update user set host=’%’ where user=‘root’;
select host,user from user;
flush privileges;
通过ip地址远程连接数据库:
mysql -h 192.168.xx.xx -u root -p
查看ip:在cmd 中 ipconfig