Lunarpages Web Hosting Forum

Author Topic: mySQL databases on a dedicated server  (Read 1713 times)

Offline bobAWR

  • Newbie
  • *
  • Posts: 4
mySQL databases on a dedicated server
« on: November 03, 2005, 07:15:41 PM »
Hello,
I have an LP's dedicated server.  I have created an account 'myaccount' on my server.  I then went to the SQL permission settings and gave this account all the privilages needed to create databases and work with them.  I then used 'myaccount' cpanel to create a database.  But the permissions I gave 'myaccount' from WHM->SQL->permissions don't seem to be sticking.  I keep having to go back in and give the permissions again.  Is there a commit function I am missing or something when I give the permissions to 'myaccount'.  The perms don't seem to last more than a few minutes and then 'myaccount' is back to the default perms and has no access to the database it created.

Thanks!

Offline TomasO

  • Spaceship Navigator
  • *****
  • Posts: 84
Re: mySQL databases on a dedicated server
« Reply #1 on: November 07, 2005, 04:16:46 AM »
How are you creating the databases? Is it over phpmyadmin or command line MySQL?
Tomas Olivares
Junior System Administrator - System Admin Team