错误代码:1044.用户被拒绝访问 [英] Error Code: 1044. Access denied for user

问题描述

使用'root'@10.0.1.15'

我试图授予用户SELECT, INSERT, UPDATE，但从MySQL得到此错误

I tried to grant a user SELECT, INSERT, UPDATE but got this error from MySQL

Error Code: 1044. Access denied for user 'root'@'10.%' to database 'abc'

这是我曾经授予的查询

GRANT SELECT, INSERT, UPDATE ON abc.* TO 'myUser'@'10.%';

之所以没有，是因为当我对"root" @'10.％'执行SHOW GRANTS时，这就是我得到的

This makes no since because when I execute SHOW GRANTS FOR 'root'@'10.%' Here is what I get

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.%' IDENTIFIED BY PASSWORD 'jklasdfksfkashdfksdfhsdlkfasdfjklasdfsjk'

我试图再次授予所有特权，但仍然遇到相同的错误.

I tried to do grant all privileges all over again but still getting the same error.

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.%';
FLUSH PRIVILEGES;

我在这里可能做错了什么?为什么用户'root'@'10.0.1.15'不能授予其他用户特权?

What I could be doing wrong here? why aren't the user 'root'@'10.0.1.15' able to GRANT other users privileges?

推荐答案

您的用户需要GRANT OPTION.

以下是更改现有赠款以解决该问题的方法:

Here's how to change your existing grant to fix that:

GRANT ALL PRIVILEGES ON *.* 
TO 'root'@'10.%' 
IDENTIFIED BY PASSWORD 'jklasdfksfkashdfksdfhsdlkfasdfjklasdfsjk' 
WITH GRANT OPTION

这篇关于错误代码:1044.用户被拒绝访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！