weixin_42627035的博客

https://blog.csdn.net/wst878882582/article/details/78457531

 1.修改/etc/mysql/my.cnf文件中的bind-address选项设置为MySQL服务器的IP。。2.修改数据库将MySQL数据库中的user表中的host列的localhost为%update user set host ='%' where host='localhost' and user='root'; --更新host3.重启mysql服务...

1.使用navicat.exe可视化工具管理数据库2.SELECT * FROM t_user WHERE uid =1;SELECT uname FROM t_user；//显示所有SELECT DISTINCT uname FROM t_user;//如需从 uname " 列中仅选取唯一不同的值SELECT * FROM t_user WHERE uid >2 AND ...