The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Users Disappearing

Discussion in 'General Discussion' started by Somethingblue, Sep 12, 2006.

  1. Somethingblue

    Somethingblue Member

    Joined:
    Sep 28, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Hey,

    The thread title pretty much says it all.

    We've been having a semi-frequent issue in which our users get a MySQL Database created, a MySQL user connected to the database, and their scripts configured accordingly.

    Somewhere along the line, the MySQL users are not only disconnected from the database, but completely removed from cPanel/the server.

    The issue is easily resolved by recreating the MySQL user and reconnecting the user to the database, but does anyone know why MySQL users are disappearing in the first place? Has anyone experienced this issue before? Is there a log file we're missing somewhere that could explain this?

    Any information you guys have would be much obliged.

    Thanks!
     
  2. pschmidt

    pschmidt Registered

    Joined:
    Dec 13, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    We have had this problem and have isolated it a little more.

    When we use MySQL account management through CPanel logged in directly as the user, it loses the user on the database.

    When we go to the same page starting from WHM, then go to cpanel, the user is not lost and we can restore it.

    Any way to fix this? Is CPanel changing permissions?

    Help!
     
  3. HostIt

    HostIt Well-Known Member

    Joined:
    Feb 22, 2003
    Messages:
    151
    Likes Received:
    1
    Trophy Points:
    18
    This has happened here also, a couple of times.

    Did you have to do something specific on the MySQL account screen in order for the db user to disappear? And was this replicated on all accounts server-wide, or only on the ones which had trouble in the first place?
     
  4. sssathish

    sssathish Member

    Joined:
    Jul 19, 2006
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Madurai, Tamil Nadu, India
    Hi,

    Do confirm that the Databases are set with correct ownership such as mysql.mysql also check the size of /var partition.
     
Loading...

Share This Page