Question: Setting Multiple Mysql Users In Cpanel

[Xoviat]

I set up additional user accounts for mysql on cpanel a couple of hours ago and they appear not to work when referencing them in PHP.

 

I've looked under information-schema in phpmyadmin and they don't exist there.

 

I'm most likely doing something wrong, the code is sound but I get an Access Denied error.

 

Any ideas on what I need to do to fix this?

[Xoviat]

This all just seems a bit odd. experimenting with it, mysql databases on cPanel appears to pass super-user privs into the schema, but none of the other user privs.

 

For the moment, I've altered the return value of my connection function so that everything's going through the super-user connection, but that's not desirable behaviour to say the least.

I can't create users via query, so I feel pretty much stuck with it.

 

Any idea as to what may have happened? Am I doing something wrong here?