I was recently trying (practicing) to create a database using the SQL command line in phpMyAdmin using my MAMP and no problem I can add and drop databases but to my surprise when I tried to create a new database in my live server I couldn’t, so I thought this was some sort of privileges that the host company needed to adjust so I contacted them and they made same adjustments but nothing, it don’t work still. I tried a different host company and the same thing it doest let me create or delete databases using phpMyAdmin so now I’m wondering if this has something to do with recent updates in my phpMyAdmin and my MAMP works because I haven't updated it (just guessing).
I know I can create databases through MySQLDatabases in cpanel but as I said I’m trying and practicing SQL commands.
Does this has something to do with phpMyAdmin and this option is simply not available?
Any idea what do I need to do to be able to create or drop databases using SQL commands in phpMyAdmin?
Oh, this is how I'm trying to create my new debases
CREATE DATABASE databaseName
DROP DATABASE databaseName
Am I doing something wrong?
Thanks a lot!