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.