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?