I'd like to put up a new site where the database is hosted in another server and the CMS (Joomla to be specific)

on my script configuration, how would i put the connection then? Would it be
host = "12.345.67.89";
username = "mydbuser";
password = "XXXXX";
db_name = "db_name";

or
host = "12.345.67.89:3306";
username = "mydbuser";
password = "XXXXX";
db_name = "db_name";

Well, I tried both but neither worked! I was told in another forum that I should allow other IP to connect (through firewall setup in cpanel) but we are using helm for our windows hosting accounts.

---

mike
http://privateshelter.com/scaredcrow --my blog

umnn... actually, i host both with hostingfest. one is windows hosting, the other is a linux hosting. :)

Pardon me, I should have asked you this through a ticket.

Thanks Guys! After the changes you made, I can now connect to the database. However, there's a new problem encounted as below



I was told it has something to do with the Joomla problem on MySQL 5 strict mode.

So I guess that's something I have to fix with Joomla, then.

thanks for your help, guys!

On this question, I am looking to write an application in vb, which will use a mySQL database hosted with you guys (can be on either windows or linux as I have both, which would be best?). Can I easily set this up using the mySQL Grant command?

Thanks
Paul

I've just set up a new database on my linux account and added a user.

In the hosts section it has access for %.%.%.%, does % mean a wildcard and therefore any IP/Machine can access the database?

I'm trying to write an application, that can be ran on any machine (which is why I wont know the IP address of the connection) and for it to be able to read/write data. The user name and password will be securely stored in the compiled application. I'll be connecting via ODBC.

Any help on this will be greatly appreciated as I have a customer very keen to get this project underway.

Thanks :)

Edited by user Wednesday, January 10, 2007 7:15:42 AM(UTC)  | Reason: Not specified

Linux server does not allow remote mysql connections.

Yes, you can do it if you have a Windows Account.

Already we did reply to your ticket.