MIKI785 Posted September 22, 2012 Posted September 22, 2012 Hello, I have a problem with dbConnect, it says: "dbConnect failed; Could not connect", why ? Everything is ok, user, password DB name.. everything. It works with other programs. handle = dbConnect( "mysql", "dbname=oh1588;host=92.240.***.**", MYSQL_USERNAME, MYSQL_PASSWORD ) I tried IP and DNS name, both doesn't work. Btw. those stars are not in the code. MYSQL_USERNAME and MYSQL_PASSWORD are defined strings, which are correct credentials. Lua Scripter Owner of mshost.cz MTA portal.
Anderl Posted September 22, 2012 Posted September 22, 2012 Are you sure MySQL server is accepting external connections? "[...] If you don’t love it, if you’re not having fun doing it, you don’t really love it, you’re going to give up." - Steve Jobs, 2007
MIKI785 Posted September 22, 2012 Author Posted September 22, 2012 Yes, because it accept connections from my PC (software called HeidiSQL) Lua Scripter Owner of mshost.cz MTA portal.
MIKI785 Posted September 22, 2012 Author Posted September 22, 2012 lol, it doesn't work even with localhost... Lua Scripter Owner of mshost.cz MTA portal.
MIKI785 Posted September 22, 2012 Author Posted September 22, 2012 try the private ip What? It doesn't work with any IP Lua Scripter Owner of mshost.cz MTA portal.
Jaysds1 Posted September 22, 2012 Posted September 22, 2012 Try using this website for mysql: http://www.bizhostnet.com/ I use it for free mysql... My in-game name: Jaysds1 Retired CMG Scripter World Of Tanks GameMode (Open-Source): https://github.com/Jaysds1/mtasa-wot-gamemode Online GUI-Editor (WIP): https://forum.mtasa.com/topic/47678-online-gui-editor/
SirniNamaz Posted September 22, 2012 Posted September 22, 2012 try the private ip What? It doesn't work with any IP i mean your internal ip address (if you have not tried already)
MIKI785 Posted September 23, 2012 Author Posted September 23, 2012 Try using this website for mysql: http://www.bizhostnet.com/I use it for free mysql... Doesn't work... still the same problem. dbConnect( "mysql", "dbname=1347157507;host=64.245.136.240;port=33006", "1347157507", "*****") As host, i tried both IP and domain... Lua Scripter Owner of mshost.cz MTA portal.
Jaysds1 Posted September 23, 2012 Posted September 23, 2012 Doesn't work... still the same problem. Here's an example of connecting to their mysql, here's your connection type: dbConnect( "mysql", "dbname=1347157507;host=free-mysql.BizHostNet.com;port=3306", "1347157507", "*****") My in-game name: Jaysds1 Retired CMG Scripter World Of Tanks GameMode (Open-Source): https://github.com/Jaysds1/mtasa-wot-gamemode Online GUI-Editor (WIP): https://forum.mtasa.com/topic/47678-online-gui-editor/
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now