Phpmyadmin Says No Privilege to Create Database, Despite Logged in as Root User

phpMyAdmin reports 'No Privileges'

This was super annoying.

It appears to be a bug with phpMyAdmin.

Clear your browser cookies, what's happening is phpMyAdmin has "cached" the fact that you do not (or possibly didn't have at some point) create database access.

There's no way to reset it other than deleting your cookies for phpMyAdmin in your browser window (to get a new 'session id'), or deleting the session files on the phpMyAdmin web server.

phpMyAdmin "Create database: Documentation No Privileges", how to create database?

This solved my issue, on ssh-ed terminal, I ran:
sudo mysql
and on the prompt:

FLUSH PRIVILEGES; 
GRANT ALL PRIVILEGES ON *.* TO 'myUsernameCreatedEarlier'@'localhost;

Then I cleared the cache/cookies on the browser on my computer (not server computer). And logged in on phpMyAdmin web portal. Now I have database creation access.

mysql user has no privileges. \s shows I am logged in correctly. Error messages refer to a user of ''@localhost

I found the answer in another thread.

There was an anonymous user defined for localhost, that was masking my actual username.

---

Related Topics