In your "user" table in the mysql database, remove all the lines that allow logins from other hosts.
mysql> use mysql mysql> delete from user where host <> "localhost; mysql> flush privileges; -ms -----Original Message----- From: Mel [mailto:[EMAIL PROTECTED] Sent: Saturday, April 05, 2003 9:38 AM To: [EMAIL PROTECTED] Subject: MySQL & security I'm running MySQL 4.0.12-standard on Mac OS X (10.2.4), for local use only. As no-one else needs access to the database, I'm trying to make it as secure as possible... so far I've added skip-name-resolve, skip-networking and safe-user-create into my.cnf. I've also seen bind-ip=127.0.0.1 mentioned a few times as well, but I'm not sure if this is needed if skip-networking is set, or if one over-rides the other? As you can probably tell, I'm on the new side to this, so any help or advice is appreciated. TIA! Mel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
