Start a second instance of MySQL

[JuTs]

Hi,

I need to start a second instance of MySQL. I would like to know if it could be a problem in case of DA update. For example could any configuration file be overwritten by the DA update ?

The reason I want to do that is that I need to access to a DB from remote places and I don't want the databases used for my website to be accessible from outside. So if there is a clever solution to do that, suggestions are welcome.

Best regards

Julien

 

[zEitEr]

Hello,

By default Directadmin when adding new MySQL users set localhost as the only allowed host to connect from. So if you have a DB userbob_wp
only user userbob_wp from localhost will be able to connect to it. And if you want to allow to connect to a DB from a remote server you'll need to create a separate user for it for example [email protected], and here the host 11.22.33.44 will be the only allowed to connect to DB userbob_wp.

So you are safe here. Another layer of protection is to use firewall and restrict access to 3306 per IP bases.

More reading: http://help.directadmin.com/item.php?id=308 and http://dev.mysql.com/doc/refman/5.5/en/connection-access.html

 

[JuTs]

I forgot a point : the DB will not be accessed from a static IP. Otherwise, yes, that would have been the solution.

Regards

Julien

 

[zEitEr]

You can specify a subnet ([email protected].%) or even ANY host (userbob_remote@%) there.
Bind MySQL to not-standard port 33036 or any other.

Of course you can run the seconds MySQL instance, and directadmin won't interfere into it. So that's up to you. More reading: http://dev.mysql.com/doc/refman/5.5/en/multiple-unix-servers.html

 

[JuTs]

Ok, that will do.

I also reduced the privileges of the user that has remote access.