Hi, folks.
I use WinXP + MySQL.
I deleted all the rows from the 'user' table of the 'mysql' database except my own account (host: localhost, user: alan, password:alan). --- I was hoping only I have the access to the MySQL databases.
The problem is that I still can login to MySQL by the DOS command: 'c:\mysql\bin\mysql' without the '-h localhost -u alan -p' followed. (NOTE: MySQL was installed under the c: drive)
And even the 'c:\mysql\bin\mysql -h localhost' and 'c:\mysql\bin\mysql -h localhost -u root' *work* too!!! Terrible!!!
(BTW, in the 'my.ini' file, the user=alan, password=alan.) --- But I don't think this is important as all of the user info are stored in the 'user' table of the 'mysql' databse. Right?
What am I gonna do? Please advise.
If you deleted the rows with a DELETE statement, you'll need to also issue a FLUSH PRIVILEGES statement to cause the server to reread the grant tables.
I am assuming that the 'alan' account that you're planning to use has all privileges. Otherwise, you will find after flushing the privileges that you'll no longer be able to administer your server without starting it with the --skip-grant-tables option...
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
