Jump to content

Question: Setting Multiple Mysql Users In Cpanel


Xoviat

Recommended Posts

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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...