[thelist] mysql security

[Anthony Baratta]

At 08:58 AM 4/17/2001, you wrote:
>Hi,
>I have a few questions about mySQL security:
>
>1.) A port scan showed me that the mySQL server is open and running at 
>port 3306. Where can I disable this?

As long as you have no users that have remote access, your OK here. But if 
you want to start mySQL without remote access available you can tweak your 
startup config file to include:

         --skip-networking

More info:
http://www.mysql.com/doc/P/r/Privileges_options.html


>2.) show databases; shows me a 'test' db that I can't drop claiming it 
>wouldn't exist. Is this a mySQL DB that is necessary?

You can drop this DB. It is not needed. What interface are you using to 
manage the DB. I don't get this message from the command line interface.

>3.) The table DB from the DB mysql shows extensive rights to the test DB 
>which scares me a bit. Simply delete or are these mySQL specific?

Just delete this info after you drop the table.
----
Anthony Baratta
President
Keyboard Jockeys