数据库
乔布斯基
请叫我乔布斯基
展开
-
mysql误删用户表数据怎么找回用户
1,my.ini 文件末尾添加skip-grant-tables2,无用户状态登录3,flush privileges;执行命令,否则报:The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement4,GRANT USAGE ON *.* TO 'r原创 2017-06-27 18:45:55 · 526 阅读 · 0 评论 -
Navicat连接Mysql报错:Client does not support authentication protocol requested by server;
Navicat连接MySQL Server8.0版本时出现Client does not support authentication protocol requested by server;1,启动MySQL 8.0 Command Line Client2,输入密码,登录Mysql3,分别输入如下命令USE mysql;ALTER USER 'root'@'l...原创 2018-12-08 00:34:50 · 472 阅读 · 0 评论