#1227 - Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation

Question

I am following the new boston mysql tutorials, and at the very beginning he is writing SHOW DATABASES. In my case I get the following error

"#1227 - Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation".

I am very new to phpmyadmin and I have googled how to grant a permission but I am unlucky

score 1 · Answer 1 · edited May 23 '17 at 12:31

1

You need to have that privilege granted to the user ie

GRANT SHOW DATABASES ON *.* TO $username_here

The docs for this can be found here

Someone here also had a similar problem with PHPMYADMIN.

Depending on your username you can also use this from the console

GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password_asljk8902314';
flush privileges;

Please make sure your username is correct.

edited May 23 '17 at 12:31

Community

answered Apr 14 '16 at 23:08

Harry

1

I tried many different times and I still get errors like this: – AngryAce Apr 14 '16 at 23:29
Do you have root access to the machine? – Harry Apr 14 '16 at 23:36
im doing it on hostinger. Its online – AngryAce Apr 15 '16 at 14:23

1 Answers1