天气预报 > 其他 > mysql连接不上
mysql连接不上
更新时间: 2020-07-10 00:00:00  

按照以下步骤操作:

以权限用户root登录;选择mysql库;查看mysql库中的user表的host值,即可进行连接访问的主机或IP名称;修改host值,使用通配符修改或直接增加IP地址;刷新MySQL的系统权限相关表;再重新查看user表有修改;重起mysql服务即可完成。

关键词: mysql 连接

mysql连接不上相关经验

天气预报

最新推荐

页面:/news/view-1399677/ | 耗时:0.9704 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=1399677 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1399677 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1399677 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1131679,1082251,1117456,251720,1130091,1063337,2662119,139026,1130720,1067886,1110484,1117011,1095930,1107130,1066622,1115485,1575667,1128900,3374060,3127644,2096273,1120801,1130808,1133121,176557,1108704,1126272,1077569,1047827,1493289) ORDER BY field (ArticleID,1131679,1082251,1117456,251720,1130091,1063337,2662119,139026,1130720,1067886,1110484,1117011,1095930,1107130,1066622,1115485,1575667,1128900,3374060,3127644,2096273,1120801,1130808,1133121,176557,1108704,1126272,1077569,1047827,1493289)