连接服务器数据库mysql

准备：需在同一局域网才可连接（连接相同的WIFI）
本地操作：
1.打开cmd
2.mysql -u root -p 输入密码
3.use mysql;（输入命令）
4.update user set host="%" where user=“root” and host=“localhost”;
5.flush privileges;

服务器打开防火墙。
参考https://blog.csdn.net/qq_42999356/article/details/106672373?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522162075237216780261980337%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=162075237216780261980337&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_allfirst_rank_v2~rank_v29-1-106672373.first_rank_v2_pc_rank_v29&utm_term=%E5%A6%82%E4%BD%95%E8%AE%A9%E5%90%8C%E4%BA%8B%E8%BF%9E%E6%8E%A5%E8%87%AA%E5%B7%B1%E6%9C%AC%E5%9C%B0%E6%95%B0%E6%8D%AE%E5%BA%93&spm=1018.2226.3001.4187