• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Solved [it can be bad forum] Can't connect to MySQL server

  • Thread starter Thread starter tejdi
  • Start date Start date
T

tejdi

Guest
Hello everybody.
All is working on localhost [127.0.0.1] but when i putted my ip [77.45.0.69] in config.lua i get error:
G8NwYYg.png

My cmd with ipconfig command:
oQwnDRf.png

My router Forwarding/Virtual Servers:
QvzG0HC.png

and my ip address:
7VUb7Fb.png
 
And my config.lua:
Code:
mysqlHost = "77.45.0.69"
mysqlUser = "root"
mysqlPass = "*******************" <-- Password is ok.
mysqlDatabase = "ots"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"
 
Hello everybody.
All is working on localhost [127.0.0.1] but when i putted my ip [77.45.0.69] in config.lua i get error:
G8NwYYg.png

My cmd with ipconfig command:
oQwnDRf.png

My router Forwarding/Virtual Servers:
QvzG0HC.png

and my ip address:
7VUb7Fb.png

You should put 77.45.0.69 on the server IP, not database address.
That's why the server can't connect to the database, because that ip should always be 127.0.0.1 unless you use distance database.
 
I posted my config.lua and i think it's ok
Should i use
Code:
mysqlHost = "127.0.0.1"
??

Can my friends connect when it will look like this?
:v
 
I posted my config.lua and i think it's ok
Should i use
Code:
mysqlHost = "127.0.0.1"
??

Can my friends connect when it will look like this?
:v
mysqlHost is correct, it should be 127.0.0.1, but then you will have to set your global IP there it says IP, I don't know what it says in your config, but Ctrl + F and search for "port" and you'll find IP or similar there.
Put your 77. ip there =)
 
Back
Top