编辑mysql配置文件my.ini，在[mysqld]这个条目下加入 skip-grant-tables
保存退出后重启mysql
但是跳过权限检查，其不是不安全吗？待解
转载：http://blog.sina.com.cn/s/blog_759a5a7c01017dj0.html
相关文章
- Centos7解决MySQL登录ERROR 1045 (28000): Access denied for user ‘‘@‘localhost‘ (using
- ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N O) MYSQL
- mysql cmd ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N O)
- 连接本地数据库出现：1045 - Access denied for user 'root'@localhost'(using password:YES) 本人解决方案：
- 解决MySql 数据库 提示：1045 access denied for user 'root'@'localhost' using password YES
- 关于Navicat mysql连接出现1045 access denied for user 'root'@'localhost' using password： yes
- 解决Navicat连接的时候出现了1045 -Access denied for user'root'@'192.168.37.2'(using password :yes)
- 当Navicat for Mysql出现 1045 -Access denied for user'root'@'ipAddress'(using password :yes)
- Navicat连接mysql：1045-Acess denied for user:'root'@'localhost'(Using password:YES)
- python连接mariadb报错解决1045, "Access denied for user 'root'@'192.168.0.50' (using password: YES)