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.
Create new database: No Privileges
Global Privileges: USAGE
Local Privileges to DB c2ssdb: ALLPRIVILES
Virtual Machine - I've allocated 1x 2.8Ghz core with 1GB Ram and 40GB HD
Ubuntu 9.04 (server with all updates)
PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch
MySQL client version: 5.0.75
PHP extension: mysqli