Can not delete the Existing MySQL users...

ThunderHostingDotCom

Well-Known Member
Nov 18, 2002
449
1
168
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:
 

cyon

Well-Known Member
PartnerNOC
Jan 15, 2003
314
0
241
is there a - in the usernames?

cPanel.net Support Ticket Number:
 

ThunderHostingDotCom

Well-Known Member
Nov 18, 2002
449
1
168
All over!
Originally posted by cyon
is there a - in the usernames?

cPanel.net Support Ticket Number:

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:
 

cyon

Well-Known Member
PartnerNOC
Jan 15, 2003
314
0
241
..but the first one has a - in it.. what is the username?

cPanel.net Support Ticket Number:
 

ThunderHostingDotCom

Well-Known Member
Nov 18, 2002
449
1
168
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:
 

cyon

Well-Known Member
PartnerNOC
Jan 15, 2003
314
0
241
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:
 

ThunderHostingDotCom

Well-Known Member
Nov 18, 2002
449
1
168
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:
 

cyon

Well-Known Member
PartnerNOC
Jan 15, 2003
314
0
241
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: