Newbie on simple security setting
Posted 27 December 2003 - 02:27 AM
Any help would be much appreciated, thanks.
Posted 27 December 2003 - 07:53 AM
Select * from users;
Look for a * in the user name column and remove that row in the table. After doing so you may have to flush priveleges;
Posted 28 December 2003 - 04:35 PM
DELETE FROM mysql.user WHERE user=\'username\' and host=\'hostname\';
However I had to do this instead
DELETE FROM mysql.user WHERE user=\'\';
I deleted two records in the mysql table. Hopefully the one record wasn\'t that important. It had a NULL username and \"localhost\" as the host.
Maybe I\'ll find out down the line. :?
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users