Anyone know how to use the MySQL Database connection?

[Luke 18]

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.

[bestmacros 60]

you need to replace localhost with your server ip

[oricoun 4]

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.

[Sirfrank 17]

freesqldatabase.com this provider allows remote access to mysql. using them for months.

[danoctav 7]

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.

[jason 101]

Don't forget these: http://wiki.ubotstudio.com/wiki/Database_Commands

[the_way 52]

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.

[Luke 18]

Awesome! Thanks a ton, everyone! I got it conencted now; yes I was on hostgator too.