Setup a remote MySQL database
-
Hello. Im running a webserver with apache and mysql 5.xx Now I want to connect to the MySQL database on a server outside my own. But it doesnt allow remote connections from my mysql database. I have port 3306 open and the firewall off. How can I setup MySQL to accept remote connection? Best Regard Mads
-
Hello. Im running a webserver with apache and mysql 5.xx Now I want to connect to the MySQL database on a server outside my own. But it doesnt allow remote connections from my mysql database. I have port 3306 open and the firewall off. How can I setup MySQL to accept remote connection? Best Regard Mads
Did you check the "Enable TCP/IP connections" option when you run the instance configuration? If not you can just reconfigure.
He never answers anyone who replies to him. I've taken to calling him a retard, which is not fair to retards everywhere.-Christian Graus
-
Did you check the "Enable TCP/IP connections" option when you run the instance configuration? If not you can just reconfigure.
He never answers anyone who replies to him. I've taken to calling him a retard, which is not fair to retards everywhere.-Christian Graus
I installed it together with wamp. And can't find such just thing in the mysql.ini .. What do I have to change in the mysql.ini to enable TCP/IP connections ?
-
I installed it together with wamp. And can't find such just thing in the mysql.ini .. What do I have to change in the mysql.ini to enable TCP/IP connections ?
-
Try this one[^] the url looks insultingly explanatory. ;) lol
He never answers anyone who replies to him. I've taken to calling him a retard, which is not fair to retards everywhere.-Christian Graus
I use windows for hosting mysql.. I have tried look in my.ini for these bind-adress and the other configs.. But can't find anything at all in my.ini that seems to have something to do with TCP/IP configuration.