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

Question

I'm just starting to learn php and mysql, and just trying to set everything up. To try out example problems for learning, I'm trying to create database by logging into the http:://my-local-ip/phpmyadmin/. I can login using the user-name and password used during installation, but trying to cretae database I see No Privileges.

I have looked at the possible duplicates, I have tried clearing cache/cookies and entering flush and the user command sql, they have not fixed my issue.

Note that, I'm not on the same computer, I have a separate computer that I'm ssh-ing into (both ubuntu 16) and I'm accessing the web-phpMyAdmin via the local ip address of the ssh-ed computer.

I'm not sure how to fix this issue.

Answer 1

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 the server computer). And logged in on the phpMyAdmin web portal. Now I have database creation access.