Page 1 of 1
cleanup mysql
Posted: Sat Jan 07, 2017 11:37 am
by Vegan
generally mysql is not a big problem
but i have one user account that is messy
it is in quotes while the rest are normal
any suggestions how to get rid of it?
Re: cleanup mysql
Posted: Sat Jan 07, 2017 7:08 pm
by requinix
Quotes?
Re: cleanup mysql
Posted: Sat Jan 07, 2017 10:28 pm
by Vegan
Code: Select all
mysql> SELECT User FROM mysql.user;
+-----------------------+
| User |
+-----------------------+
| azureguru |
| globalecon |
| hardcorecomputerchess |
| hardcoregames |
| hardcoregamesredirect |
| hivresearch |
| linuxguru |
| veganadvocate |
| windowsguru |
| debian-sys-maint |
| mysql.sys |
| root |
| ‘linuxguru’ |
+-----------------------+
13 rows in set (0.28 sec)
Re: cleanup mysql
Posted: Sat Jan 07, 2017 10:36 pm
by requinix
You already have a "linuxguru" user. Want to drop the other one? The username and host are strings, not identifiers, so you'd use ' or " to quote them.
Code: Select all
DROP USER '`linuxguru`'@'whatever';
Re: cleanup mysql
Posted: Sun Jan 08, 2017 8:40 pm
by Vegan
requinix wrote:You already have a "linuxguru" user. Want to drop the other one? The username and host are strings, not identifiers, so you'd use ' or " to quote them.
Code: Select all
DROP USER '`linuxguru`'@'whatever';
I have tried that it does not work
DROP USER '`linuxguru`'@'%';
operator drop user failed
Re: cleanup mysql
Posted: Sun Jan 08, 2017 8:44 pm
by requinix
Do you have the permissions for it?
Re: cleanup mysql
Posted: Mon Jan 09, 2017 2:38 pm
by Vegan
I am using the root account
Re: cleanup mysql
Posted: Mon Jan 09, 2017 9:24 pm
by requinix
Then what was the exact error message?