I am unable to create MySQL databases. Some background:
-My (sub)account was created by the owner of this account, he believes he has given me every possible permission.
-The blue ‘Create a new MySQL database’ box, as seen on the page
is not visible when go to the page in the Panel - Goodies - Manage MySQL. It is visible for the main account owner. I can, however, create new hostnames.
-I can log in with PHPMyAdmim, and it shows that I have permission to create databases. However, if I try to do so, it gives the following error:
ERROR 1044 (42000): Access denied for user ‘my_user’@‘126.96.36.199/255.255.224.0’ to database ‘db1’
-I created a new hostname with nothing on it, waited for it to become active, logged onto my shell account, logged into that host via the mysql command line utility, and tried to create the database there. Same error message.
Question 1: Is it even possible for me to create databases, or must I bug the account owner (which he does NOT appreciate) every time a database needs to be created?
Question 2: If I can create databases myself, how?
Thanks in advance…