I have a linux VPS. I want to be able to create a database via SSH and still have access to it via CPanel. I tried creating a database using
create database myDB and it did create it and I can see it when I use
show databases; but I cannot see it when I log in to my control panel as
myUser. I did try granting permissions to
myUser on that database but it didn't seem to help (unless I did it wrong).
Can someone point me in the right direction please?
Using CentOS and MySQL5.