Error: I can't create new databases and the database 'c2ssdb' doesn't exist (user 'c2ssdbadmin' doesn't have CREATE DATABASE permissions.)
The issue is that the database "c2ssdb" DOES exist and the user c2ssdbadmin has full security access (to said database). I've already verified that I am using the correct username/password (logged into phpmyadmin quite successfully using this user/pass pair).
It is true that the user does not have "CREATE DATABASE" privilages - but if the database is already created, why is this an issue? What is the expected behavior?
If I resort to using the root user, there is no problem, and installation goes through just fine. For obvious reasons, this isn't really an option.
----USER INFO----
User: cs22db
Create new database: No Privileges
Global Privileges: USAGE
Local Privileges to DB c2ssdb: ALLPRIVILES
----CONFIG----
Virtual Machine - I've allocated 1x 2.8Ghz core with 1GB Ram and 40GB HD
Ubuntu 9.04 (server with all updates)
Apache/2.2.11 (Ubuntu)
PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch
mod_ssl/2.2.11
OpenSSL/0.9.8g
MySQL client version: 5.0.75
PHP extension: mysqli