MySQL privileges

[falsedawn]

Hi,
I created a new cpanel account in WHM, but can't seem to get the mysql privileges to work. Either it appears as "no privileges" when i use phpmyAdmin in the cpanel account, or if I try to add privileges in WHM, the cpanel account can see all the databases, which is not good.
Any pointers as to how to set it so each cpanel accout can create databases, but only see the ones they create?
Thanks.

[nhdonny]

I'm waiting to see the answer too. I'm sure we can use ssh to Grant privileges but it should be working in cPanel especially when I grant All.

[BornOnline]

I'm pretty sure you need to create all your databases with the "MySQL Databases" link in cpanel and not through phpmyadmin.

[falsedawn]

Yes, that works, but any idea why there's a big red "no privileges" in phpMyAdmin in that case?

[nhdonny]

I'm wondering if this is only with Fantastico created dbs. It does not create or use a dba for the connection. If it uses our root dba perhaps it is revoking privilages.

Just wild guessing...