Home / server / Questions / 485959
In Process
Michelangelo
Asked: 2013-03-09 04:44:22 +0800 CST

Add a trust hostname in mysql

  • 772

how have I to add a trusted hostname in the mysql configuration?

webserver.mysomain.com
dbserver.mydomain.com

I would like to add the webserver.mydomain.com in the mysql database installed in the dbserver.mydomain.com

so all the connections that come from the webserver.mydomain.com must be accepted.

thanks

mysql

1 Answers

  1. I am not sure what you are trying to achieve here nor whether mysql has a concept of trusted hosts. But if you are doing this for security reasons, then do it at the user level when adding users in mysql. In other words, you will have to setup a user in mysql which connects from the webserver only, you can do this through the grant privileges options -

    mysql> grant all privileges on *.* to [email protected] identified by 'password';
mysql> flush privileges;

    On top of that, modify your firewall rules to allow mysql connections, port 3306, from webserver.mydomain.com - In iptables you can do it this way:

    /sbin/iptables -I INPUT -s webserver-ip-address -p tcp --dport 3306 -j ACCEPT
    • 2