Granting privileges on MySQL

Question

I have a MySQL database that I'm using for testing of a C# application. As a superuser, I enter the following 'query':

GRANT ALL PRIVILEGES ON testing.* TO 'Ubuntu'@'localhost';

to an affirmative message. Then, I log out of the database, log back in as Ubuntu, and run the following query on a localhost connection:

USE testing;

and receive this message:

ERROR 1044(42000): Access denied for user 'ubuntu'@'localhost' to database 'testing'

I've also run this query:

GRANT ALL PRIVILEGES ON testing.* TO 'Ubuntu'@'%';

with the same result.

What exactly am I missing? It seems like a fairly straightforward procedure...

On a side note, MySQL and operating system user accounts are distinct. You don't need to log in and out of Ubuntu to "change" the user you connect to MySQL with. — Marcello Romani, Jul 02 '13 at 20:27

AMADANON Inc. · Answer 1 · 2013-07-02T20:43:32.913

2

You need to flush the privileges:

FLUSH PRIVILEGES;

As Ricky pointed out (what is this, the mutual admiration society?!) usernames are case-sensitive, so the user Ubuntu is different from the user ubuntu

edited Jul 02 '13 at 20:43

answered Jul 02 '13 at 20:22

AMADANON Inc.

5,753
21
31

Ricky Mutschlechner · Accepted Answer · 2013-07-02T20:31:30.720

1

I believe usernames are case-sensitive. In your queries, I see that you are granting permissions to "Ubuntu" which is uppercase, but in your error message, "ubuntu" is lowercase.

Also, as pointed out by AMADANON Inc., you will most likely need to run the query

FLUSH PRIVILEGES;

in order for the permissions to actually kick in.

edited Jul 02 '13 at 20:31

answered Jul 02 '13 at 20:23

Ricky Mutschlechner

4,291
2
31
36

Wondering if I can give credit to both you and Amadanon... both helped. – nerdenator Jul 02 '13 at 20:27
3

I think you can only mark one answer as correct. I'd rather Ricky gets credit than no-one at all. – AMADANON Inc. Jul 02 '13 at 20:29
I'm not sure if that's possible, but thanks for letting me/us know that it worked! – Ricky Mutschlechner Jul 02 '13 at 20:29
@AMADANONInc. much appreciated! I will add your part into my answer as well, making it the "best answer" for anyone who may stumble upon this. – Ricky Mutschlechner Jul 02 '13 at 20:30

Granting privileges on MySQL

2 Answers2