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.

Sorry, a mysql user with the name * already exists.

Discussion in 'General Discussion' started by ipvhost.ro, Mar 10, 2011.

  1. ipvhost.ro

    ipvhost.ro Registered

    Joined:
    Oct 8, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    Hello

    I have terminate an account, and I wanted to restore it from backup but I get this error:

    Account Creation Status: failed (Sorry, a mysql user with the name th454 already exists.)

    Account Restore Failed... Restore failed.

    I verify from shell, and I was able to create the user th454, actually user does not exist before:
    mysql> CREATE USER 'th454'@'localhost' IDENTIFIED BY 'some_pass';
    Query OK, 0 rows affected (0.00 sec)


    After I drop the user:
    mysql> DROP USER 'th454'@'localhost';
    Query OK, 0 rows affected (0.01 sec)


    Now I try again to restore the account but:

    Account Creation Status: failed (Sorry, a mysql user with the name th454 already exists.)

    Account Restore Failed... Restore failed.


    Conclusion: The user does not exist, but cpanel sees the user there.

    thanks,
     
    #1 ipvhost.ro, Mar 10, 2011
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,489
    Likes Received:
    29
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    What is your cPanel & WHM version number?
     
    #2 cPanelKenneth, Mar 10, 2011
  3. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,840
    Likes Received:
    19
    Trophy Points:
    143
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    First, check a second time for any MySQL user by that name:

    Code:
    mysql> use mysql;
mysql> select User, Host from user where User like '%th454%';
    After confirming that no MySQL user by that name exists, look in /var/cpanel/databases/users.db. If the user is listed there, remove it.

    If this does not help, please submit a ticket. I have seen a few isolated instances of this happening in recent versions of the product, and if there is a problem that is causing this to happen, we need to be able to look directly at examples so that we may isolate and identify any potential problem.
     
    #3 cPanelJared, Mar 10, 2011
  4. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    316
    Location:
    Long Beach, NY
    cPanel Access Level:
    Root Administrator
    Any fix for this yet? I have just encountered this for the second time in about a week.

    The number of bugs that are impacting critical day-to-day functionality of cpanel operation seems to be at an all time high.

    I specifically run the stable build because I am trying to avoid these types of scenarios.

    Perhaps cpanel needs to re-evaluate its process for releasing a build as stable.

    Thanks.

    mrk
     
    #4 lbeachmike, Apr 13, 2011
  5. forlinuxsupport

    forlinuxsupport Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2004
    Messages:
    386
    Likes Received:
    0
    Trophy Points:
    166
    cPanel Access Level:
    Root Administrator
    Can we simply remove it and will it be recreated ?
     
    #5 forlinuxsupport, May 30, 2011
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,622
    Likes Received:
    24
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Yes, you can simply remove it and it should not be recreated.
     
    #6 cPanelTristan, May 31, 2011
  7. twigs76pc

    twigs76pc Registered

    Joined:
    Feb 12, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    I am also having the same issue, and I have submitted a ticket, #2283798 to support. I am running WHM 11.30.6 (build 3) on CENTOS 6.2 i686 virtuozzo at Interserver.net. I gave them access to the server to help diagnose the issue. I have also looked at my user.db and the affected user (noodlent) does not exist. However, when I go to 'Manage Wheel Group Users', the user shows up there.

    Anyone else come up with a solution yet?

    UPDATE: From Michael Photakis, Technical Analyst 2 at cPanel:

    "Hello.

    It looks like that user is still present in your passwd files, and in /etc/dbowners. You'll need to manually remove the user from the dbowners file, and you'll probably want to run "userdel noodlent" to remove the user from your passwd files."

    This is what solved my issue. Hope it helps someone else.
     
    #7 twigs76pc, Feb 12, 2012
    Last edited: Feb 12, 2012
  8. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    316
    Location:
    Long Beach, NY
    cPanel Access Level:
    Root Administrator
    There neeeds to be greater prioritization for resolving these very basic issues. I am still encoutering the issue of mixed case emails not working and amazed that such a basic issue could be left in the product for such an extended period of time.
     
    #8 lbeachmike, Feb 12, 2012
(You must log in or sign up to post here.)
Loading...
Similar Threads - Sorry mysql user
  1. alexanderu

    CreateAcct 'Sorry you must choose a package'

    alexanderu, Apr 20, 2017, in forum: General Discussion
    Replies:
    5
    Views:
    163
    Infopro
    Apr 21, 2017
  2. elis albaghi

    New subdomain and user "sorry!" error

    elis albaghi, Apr 6, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    11
    Views:
    379
    Infopro
    Apr 9, 2017
  3. Mohamed Shaarawy

    Sorry, you do not have access to the domain

    Mohamed Shaarawy, Feb 6, 2017, in forum: E-mail Discussions
    Replies:
    3
    Views:
    387
    NOC_Serverpoint
    Feb 7, 2017
  4. mhcheong

    cPanel Sorry Page when accessing sub domain

    mhcheong, Sep 14, 2016, in forum: Bind / DNS / Nameserver Issues
    Replies:
    2
    Views:
    769
    cPanelMichael
    Sep 22, 2016
  5. ltoso

    smtp; 553 sorry, invalid HELO hostname (#5.7.1)

    ltoso, Jan 4, 2016, in forum: E-mail Discussions
    Replies:
    3
    Views:
    1,085
    cPanelMichael
    Feb 2, 2016

Share This Page