Hi Sam, There are many methods and you should alsways employ more than one. The first is to use the grant system inside of mysql http://dev.mysql.com/doc/mysql/en/GRANT.html
If you want no network access at all use --skip-networking Don't listen for TCP/IP connections at all. All interaction with mysqld must be made via named pipes (on Windows) or Unix socket files (on Unix). This option is highly recommended for systems where only local clients are allowed. http://dev.mysql.com/doc/mysql/en/Server_options.html Also you could use a firewall between your system and the outside world. If you need to allow outside access use a VPN. If that is not an option some systems employ "wrappers" look at /etc/hosts.allow or hosts_access. You could also install a software firewall on your system. But this is outside the scope of this mailing list. Hope this helps, Ken ----- Original Message ----- From: "Sam" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 12, 2004 3:31 PM Subject: How to protect MySQL server from intruders ? > Hello Group .... > > I would like to know if there is some thing I can do > during the configuration of MySQL server so that I > could restrict only one user from accessing the > database and all others are restricted from the access > of the databas? > > I mean I do not want anybody else to access the > database from the outside world, except one particular > application (with one username and password) which I > would like to give access to , that would be running > in the same system as the database .... > > Bottomline restrict the outside world traffic for the > database !!! > > ===== > > Sam > > _o /\ ---- __o > -< \_ / \ ---- < \, > __(_)/_(_)________/ \_______(_) /_(_)__ > > > > > > > > > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Tax Center - File online by April 15th > http://taxes.yahoo.com/filing.html > > -- > 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]
