![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql导入
wycsdnblog
菜鸟也会有起飞的时候
展开
-
sql导入出错了?!!!试试这句吧!!The user specified as a definer ('root'@'%') does not exist 解决方法
The user specified as a definer (‘root’@’%’) does not exist 解决方法:::====》》》》》》》》》》》》grant all privileges on . to root@"%" identified by “.”;原创 2019-06-08 22:23:20 · 166 阅读 · 0 评论 -
The user specified as a definer ('root'@'%') does not exist
权限问题,授权 给 root 所有sql 权限解决办法:grant all privileges on . to root@"%" identified by “.”;原创 2019-06-08 22:26:03 · 120 阅读 · 0 评论 -
用navicat localhost或者127.0.0.1可以连接mysql,但无法用本机ip或者远程ip连接的mysql问题
在window环境下:Windows的mysql:解决办法:C:\Users\Administrator>net start mysqlC:\Users\Administrator>mysql -uroot -p123-p后面的123是密码。注意将123改成自己mysql的密码赋予所有用户远程连接权限:mysql>grant all privileges o...原创 2019-07-20 21:32:06 · 2270 阅读 · 0 评论