首页 > 代码库 > 错误代码: 1045 Access denied for user 'skyusers'@'%' (using password: YES)

错误代码: 1045 Access denied for user 'skyusers'@'%' (using password: YES)

1. 错误描写叙述

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY ".";

1 queries executed, 0 success, 1 errors, 0 warnings

查询:grant all privileges on *.* to root@"%" identified by "."

错误代码: 1045
Access denied for user ‘skyusers‘@‘%‘ (using password: YES)

运行耗时   : 0 sec
传送时间   : 0 sec
总耗时      : 0.003 sec

2. 错误原因

连接数据库的账户是skyusers,而不是root

3. 解决的方法

改动以下的MySQL命令
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY ".";
改动成
GRANT ALL PRIVILEGES ON *.* TO skyusers@"%" IDENTIFIED BY ".";
<script type="text/javascript"> $(function () { $(‘pre.prettyprint code‘).each(function () { var lines = $(this).text().split(‘\n‘).length; var $numbering = $(‘
    ‘).addClass(‘pre-numbering‘).hide(); $(this).addClass(‘has-numbering‘).parent().append($numbering); for (i = 1; i <= lines; i++) { $numbering.append($(‘
  • ‘).text(i)); }; $numbering.fadeIn(1700); }); }); </script>

错误代码: 1045 Access denied for user &#39;skyusers&#39;@&#39;%&#39; (using password: YES)