How to strengthen Mysql database server Security?

Posted by i need help on Stack Overflow See other posts from Stack Overflow or by i need help
Published on 2009-10-20T08:31:09Z Indexed on 2010/05/06 9:38 UTC
Read the original article Hit count: 175

Filed under:
|
|
|
  1. If we were to use server1 for all files (file server), server2 for mysql database (database server). In order for websites in server1 to access to the database in server2, isn't it needed to connect to to ip address of second (mysql server) ?

In this case, is remote mysql connection.

However, I seen from some people comment on the security issue.

remote access to MySQL is not very secure. When your remote computer first connects to your MySQL database, the password is encrypted before being transmitted over the Internet. But after that, all data is passed as unencrypted "plain text". If someone was able to view your connection data (such as a "hacker" capturing data from an unencrypted WiFi connection you're using), that person would be able to view part or all of your database.

So I just wondering ways to secure it?

  1. Allow remote mysql access from server1 by allowing the static ip adress
  2. allow remote access from server 1 by setting port allowed to connect to 3306
  3. change 3306 to other port?

Any advice?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about database