Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Can not delete the Existing MySQL users...

Discussion in 'General Discussion' started by ThunderHostingDotCom, Aug 19, 2003.

  1. ThunderHostingDotCom

    ThunderHostingDotCom Well-Known Member

    Joined:
    Nov 18, 2002
    Messages:
    449
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    All over!
    Under MySQL databases I can not delete the Existing MySQL users. I click on the red circled x & it says it was deleted but when I go back into MySQL databases they are still there.

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 ThunderHostingDotCom, Aug 19, 2003
  2. webfeatus

    webfeatus Active Member

    Joined:
    Jul 28, 2003
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    Bali
    same problem

    any ideas?

    cPanel.net Support Ticket Number:
     
    #2 webfeatus, Aug 20, 2003
  3. cyon

    cyon Well-Known Member
    PartnerNOC

    Joined:
    Jan 15, 2003
    Messages:
    320
    Likes Received:
    0
    Trophy Points:
    166
    is there a - in the usernames?

    cPanel.net Support Ticket Number:
     
    #3 cyon, Aug 20, 2003
  4. ThunderHostingDotCom

    ThunderHostingDotCom Well-Known Member

    Joined:
    Nov 18, 2002
    Messages:
    449
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    All over!

    No, but there is a _ in them...

    texas-sm_xmb4
    texassm_pchat1
    texassm_xmb1
    texassm_xmb2
    texassm_xmb3
    texassm_xmb4

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 ThunderHostingDotCom, Aug 20, 2003
  5. cyon

    cyon Well-Known Member
    PartnerNOC

    Joined:
    Jan 15, 2003
    Messages:
    320
    Likes Received:
    0
    Trophy Points:
    166
    ..but the first one has a - in it.. what is the username?

    cPanel.net Support Ticket Number:
     
    #5 cyon, Aug 20, 2003
  6. ThunderHostingDotCom

    ThunderHostingDotCom Well-Known Member

    Joined:
    Nov 18, 2002
    Messages:
    449
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    All over!
    Yes there is a dash in the main account username but none of the other ones will delete either. This is a reseller of mine. I never put a dash in my usernames. Is that the problem?

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 ThunderHostingDotCom, Aug 20, 2003
  7. cyon

    cyon Well-Known Member
    PartnerNOC

    Joined:
    Jan 15, 2003
    Messages:
    320
    Likes Received:
    0
    Trophy Points:
    166
    yes I guess.. I don't look through.. but after an /upcp all new usere with a dash will also have one in the mysql user username.. and if there are some old ones and you will delete them, cpanel tries to delete texas-sm_pchat1.. this gives an error because the 'real' user has the name texassm_pchat1.
    is this one also undeletable: texas-sm_xmb4

    and have an exact look at the error output.. you can see the problem there..

    its possible to delete databases manualy in root, but I dont know if it's possible to delete users manually..

    cPanel.net Support Ticket Number:
     
    #7 cyon, Aug 20, 2003
  8. ThunderHostingDotCom

    ThunderHostingDotCom Well-Known Member

    Joined:
    Nov 18, 2002
    Messages:
    449
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    All over!
    I had him go into WHM & change the username to texassm without the - in it & he was then able to delete the MySQL users with no problem.

    Thanks for all the help!

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 ThunderHostingDotCom, Aug 20, 2003
  9. cyon

    cyon Well-Known Member
    PartnerNOC

    Joined:
    Jan 15, 2003
    Messages:
    320
    Likes Received:
    0
    Trophy Points:
    166
    nice!
    but don't forget, if the user has his username in some php skripts and so on, he have to edit them all..
    To bypass this, you could change the username back to the original name after he has deleted the mysql users..

    cPanel.net Support Ticket Number:
     
    #9 cyon, Aug 20, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - delete Existing MySQL
  1. z3d3m0n

    emails deleted from inbox

    z3d3m0n, Aug 9, 2018 at 6:06 AM, in forum: E-mail Discussion
    Replies:
    6
    Views:
    70
    cPanelMichael
    Aug 13, 2018 at 10:59 AM
  2. 000

    Can I delete this 100GB devicemapper data file?

    000, Jul 20, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    93
    cPanelMichael
    Jul 20, 2018
  3. CT-NetService

    MDBox -> maildir format conversion - delete old storage/keep old files removal

    CT-NetService, Jul 19, 2018, in forum: E-mail Discussion
    Replies:
    1
    Views:
    84
    cPanelMichael
    Jul 20, 2018
  4. triatlas

    SOLVED Cannot delete old local.ini

    triatlas, Jul 6, 2018, in forum: EasyApache
    Replies:
    2
    Views:
    67
    Infopro
    Jul 6, 2018
  5. Ade Adesokan

    SOLVED Restoration of deleted files and backup

    Ade Adesokan, Jun 26, 2018, in forum: Database Discussion
    Replies:
    6
    Views:
    185
    Ade Adesokan
    Jun 27, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice