Luke 18 Posted September 30, 2013 Report Share Posted September 30, 2013 I'd really like to dive into the new Database commands, but I haven't even been able to get it to connect to one, since there is no tute nor documentation on this new functionality. I've made a MySql database through cpanel on my shared webhost, and have all the credentials to put in the "connect to database" feilds, but it never connects.... I suspect I'm not formatting host properly. All examples here on this forum & on the Wiki mention using "localhost" as the host, but that didn't work, I'd assume because I'm hosting the DB at a web host. I've tried variation of my host's login URL, but none of them work either. Anyone know how it's done? Thanks in advance. Quote Link to post Share on other sites
bestmacros 60 Posted September 30, 2013 Report Share Posted September 30, 2013 you need to replace localhost with your server ip Quote Link to post Share on other sites
oricoun 4 Posted September 30, 2013 Report Share Posted September 30, 2013 I had same problem with hostgator. I coulnt connect. Then I navigated in cpanel to:"Remote Database Access Hosts" and I added my home IP address.After that I was able to connect to DB. 2 Quote Link to post Share on other sites
Sirfrank 17 Posted September 30, 2013 Report Share Posted September 30, 2013 freesqldatabase.com this provider allows remote access to mysql. using them for months. Quote Link to post Share on other sites
danoctav 7 Posted September 30, 2013 Report Share Posted September 30, 2013 If your database is on hostgator,then this actions are required to connect to your database: 1. Go to "Database" in your cPanel and click "Remote MySQL" then add your computer IP on Remote Database Access Hosts -> Add Access Host If the IP is dynamic and some numbers not change from this IP, you can use a wildcard : "%" (like 92.123.%.%).2.On UbotStudio, this snippet work for connection to database: plugin command("DatabaseCommands.dll", "connect to database", "server=X.X.X.X;uid=userdb ; pwd=userpassword; database=yourdatabase; port=3306; pooling=false") { } * where X.X.X.X is IP (from hosting account) Also it works the same with main domain instead hosting acc. IP. 1 Quote Link to post Share on other sites
jason 101 Posted September 30, 2013 Report Share Posted September 30, 2013 Don't forget these: http://wiki.ubotstudio.com/wiki/Database_Commands Quote Link to post Share on other sites
the_way 52 Posted September 30, 2013 Report Share Posted September 30, 2013 remember to put the query/query result inside the connect to database every time, and you need to run the connect to database node, which then runs the queries inside. Quote Link to post Share on other sites
Luke 18 Posted October 1, 2013 Author Report Share Posted October 1, 2013 Awesome! Thanks a ton, everyone! I got it conencted now; yes I was on hostgator too. 1 Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.