How to strengthen Mysql database server Security?
- by i need help
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?
Allow remote mysql access from server1 by allowing the static ip adress
allow remote access from server 1 by setting port allowed to connect to 3306
change 3306 to other port?
Any advice?