mysql Access denied for user 'root'@'localhost' (using password: YES) mysql 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 看一下root用户的host字段 错误日志的话,没有错误的信息,有警告的数据2014-03-13 18:05:25 8724 [Note] Server hostname (bind-address): '*'; port: 33062014-03-13 18:05:25 8724 [Note] IPv6 is available.2014-03-13 18:05:25 8724 [Note] - '::' resolves to '::';2014-03-13 18:05:25 8724 [Note] Server socket created on IP: '::'.2014-03-13 18:05:25 8724 [Warning] Found invalid password for user: 'root@%'; Ignoring user2014-03-13 18:05:25 8724 [Warning] Found invalid password for user: '[email protected]'; Ignoring user2014-03-13 18:05:25 8724 [Warning] Found invalid password for user: 'root@::1'; Ignoring user2014-03-13 18:05:26 8724 [Note] Event Scheduler: Loaded 0 events2014-03-13 18:05:26 8724 [Note] D:\mysql56\bin\mysqld: ready for connections.Version: '5.6.16-enterprise-commercial-advanced' socket: '' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial) ::1 是啥应该是localhost才对 没有给root设置访问localhost的权限。 我使用skip_grant_tables进入到MYSQL后,修改权限,它提示说在skip_grant_tables状态下无法修改权限;请教如何给root设置访问localhost的权限 sh mysqld_safe --skip-grant-tablesUPDATE user SET password=PASSWORD("1iDOBBa57kuUlyj2") WHERE user='root';=============本地直接连Mysql 用的是localhost 谢谢大家的帮忙,这个问题我已经解决,解决过程是参考这个文章:http://holy2010.blog.51cto.com/1086044/684117 其实我并没有按上面那个文章所说把data目录给删除,它上面有一句delete from user where user='';提醒了我,可以看我的第一个截图,就是有一个用户为空的用户存在;我使用skip_grant_tables登陆到mysql之后将这个用户给删除后,再禁用,并重启mysql服务之后,就可以正常访问mysql数据库了 ?my.cnf有关binlog 和innodb 设置的参数 mysql_close和MYSQL_RES*的问题 数据导出问题 求助一个更新语句 这个错误怎么解决:Query execution was interrupted 优化一个SQL语句 哪里有mysql帮助手册下载 MySql 上亿记录处理问题 !!!! mysql rowtype的问题 用了order by以后数据查询特别慢,帮我看下吧 sql根据一个表更新另外的表 求助! sql语句优化
看一下root用户的host字段
错误日志的话,没有错误的信息,有警告的数据
2014-03-13 18:05:25 8724 [Note] Server hostname (bind-address): '*'; port: 3306
2014-03-13 18:05:25 8724 [Note] IPv6 is available.
2014-03-13 18:05:25 8724 [Note] - '::' resolves to '::';
2014-03-13 18:05:25 8724 [Note] Server socket created on IP: '::'.
2014-03-13 18:05:25 8724 [Warning] Found invalid password for user: 'root@%'; Ignoring user
2014-03-13 18:05:25 8724 [Warning] Found invalid password for user: '[email protected]'; Ignoring user
2014-03-13 18:05:25 8724 [Warning] Found invalid password for user: 'root@::1'; Ignoring user
2014-03-13 18:05:26 8724 [Note] Event Scheduler: Loaded 0 events
2014-03-13 18:05:26 8724 [Note] D:\mysql56\bin\mysqld: ready for connections.
Version: '5.6.16-enterprise-commercial-advanced' socket: '' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial)
应该是localhost才对
本地直接连Mysql 用的是localhost