Windows Accessing Database

[Heliox]

Hello! I was wondering if there is ANY way I could host my OTServer from my cousins computer, BUT access the MySQL database that I'm already running on my own computer. I was thinking something like:


-- Database
sqlType = "mysql"
sqlHost = "http://randomot.no-ip.org/phpmyadmin"
sqlPort = 3306
sqlUser = "root"
sqlPass = "hello14"
sqlDatabase = "pr"

Was thinking if that is possible. I need a respond ASAP.

 

[JayBeee]

Replace "http://randomot.no-ip.org/phpmyadmin"

with your global IP instead, so it'd be like sqlHost = "127.0.0.1"

Not with http:// before and not with/phpmyadmin.

 

[SasirO]

so its possible to host the database and site on a separated computer then ots?

so it would look like:
Dedicated Server which is hosting site and mysql database
Dedicated Server which is hosting OT

 

[Heliox]

-- Database
sqlType = "mysql"
sqlHost = "96.249.171.167"
sqlPort = 3306
sqlUser = "root"
sqlPass = "hello14"
sqlDatabase = "pr"

So if that is my global IP my cousin when running the server, the server will automatically access the database and the accounts?

 

[Grehy]

He needs to set up xampp etc just like you would, you just connect to the data base with:

youriphere/phpmyadmin

instead of

127.0.0.1/phpmyadmin

 

[JayBeee]

-- Database
sqlType = "mysql"
sqlHost = "96.249.171.167"
sqlPort = 3306
sqlUser = "root"
sqlPass = "hello14"
sqlDatabase = "pr"

So if that is my global IP my cousin when running the server, the server will automatically access the database and the accounts?

Yes, if you've opened your 3306 port, so that the server can connect to the SQL-server.