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?
cleanup mysql
Moderator: General Moderators
cleanup mysql
Hardcore Games™ Legendary is the Only Way to Play™
My site is powered by LAMP
My site is powered by LAMP
Re: cleanup mysql
Quotes?
Re: cleanup mysql
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)
Hardcore Games™ Legendary is the Only Way to Play™
My site is powered by LAMP
My site is powered by LAMP
Re: cleanup mysql
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
I have tried that it does not workrequinix 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';
DROP USER '`linuxguru`'@'%';
operator drop user failed
Hardcore Games™ Legendary is the Only Way to Play™
My site is powered by LAMP
My site is powered by LAMP
Re: cleanup mysql
Do you have the permissions for it?
Re: cleanup mysql
I am using the root account
Hardcore Games™ Legendary is the Only Way to Play™
My site is powered by LAMP
My site is powered by LAMP
Re: cleanup mysql
Then what was the exact error message?