Lua External MySQL server

[ijjvan]

Hello,

I have three servers. One as a web server, one with TFS, and a MySQL server. How do I connect TFS config.lua against an external MySQL database?

etc.

- MySQL
mysql host = "my.external.server.ip"
mysql user = "user"
mysql pass = "password"
mysql database = "database"
MySQL port = 3306

When I use localhost a.ka 127.0.0.1 so it works without problems. But once I enter my server, etc mysql.domain.com it will not work.

Does anyone know?

Thank you for so long!

 

[Royal Inferno]

There are a couple of nice full tutorials on how to make a server from scratch.
Search for "From nothing to a fully working ot" or similar on google, and you'll get to Znote's video, and it's really helpful.

Edit: Link: http://otland.net/f479/video-tutorial-nothing-fully-working-ot-server-website-shop-system-166818/

 

[ijjvan]

Well thats not the issue, i got the mysql server up and running on my own computor but lets say i want to have the sql server running on a remote site with (ofcourse) a complete different IP adress. What would i need to change ? and simply changing the IP adress in config.lua is not working.
And the ports is open on my router (3306) and the other router also has 3306 open.

 

[GoalTV]

Hello.

Try add new user in phpmyadmin with you're Domain Name.

ScreenShoot

Best Regards
mlody.1039