PDA

View Full Version : Remote MySQL

DJBenson
03-09-2005, 12:37 PM
I run a discussion site at www.my-yamada.co.uk powered by phpBB2 but I want to be able to test patches and mods on another server using the existing database hosted by HR.

On my other site (www.djbenson.f2s.com) I've installed phpBB and overwritten the config.php file with the one from the working HR install but replaced "localhost" with "www.my-yamada.co.uk" as the database host - is this right?

I've tried www.my-yamada.co.uk, my-yamada.co.uk and the IP address of the server but all fail to connect.

Is the port number required at the end of the server name/IP address?

I've also added www.djbenson.f2s.com, the IP address and the "%" wildcard to the allowed hosts part of the MySQL config in the HR control panel but no connection.

What am I doing wrong?
Viper007Bond
03-09-2005, 01:02 PM
So my-yamada.co.uk, the username, and password are in config.php and the IP address of the other box is allowed access? Odd, it should work...

I've done it before from my home PC (I'm running Apache/PHP/MySQL on my home PC) just fine.
DJBenson
03-09-2005, 01:07 PM
I've used the % wildcard so that should allow access by any machine giving the right login details shouldn't it?

This is really bugging me now - everything appears to be right.

Does it matter if it's my-yamada www.my-yamada or the IP address or should they all work?
Silmaril8n
03-09-2005, 03:25 PM
I think you need to request for remote access to MySQL.
Viper007Bond
03-10-2005, 10:09 AM
You have to manually request it?
DJBenson
03-10-2005, 10:16 AM
Well I sent in a TT and HR said that I'd done everything right but they granted permissions from their end and somehow it started to work so a big thumbs up to HR support again! :D
Viper007Bond
03-10-2005, 11:20 AM
Glad you got it working! :)
Silmaril8n
03-10-2005, 12:22 PM
You have to manually request it?
I'm pretty sure that the servers by default are only configured to accept connection from the itself. If you go through the TT system you'll find that one of them is for requesting remote MySQL access. I needed it once for a VB application that I was working on.
Viper007Bond
03-10-2005, 01:53 PM
Ah, I musta requested it then way back.