Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Connect to MySQL via IP

Quote Reply
Connect to MySQL via IP
Hi:

i am setting up a new server, which does not have a server name yet, just an IP address. As a test, i changed the database path to the ip from the existing url... but it did not take. The error message gave no reason. Will setup not take an ip addy, or should I look for problems elsewhere...
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [carfac] Connect to MySQL via IP In reply to
as far as i can see there should be no problem when you set


Code:
'host' => 'yourip'


what kind of error message do you get?

Regards

Niko
Quote Reply
Re: [el noe] Connect to MySQL via IP In reply to
Error: Could not connect to database. Reason:

not exactly helpful... ok, if this should work, i will look at other things...
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [carfac] Connect to MySQL via IP In reply to
hmm, i have no idea but would try error checking by installing mysqlman

you can enter the connection information manually

or try to connect with a small perl listing which shows the tables or something like that.

regards and good luck

niko
Quote Reply
Re: [el noe] Connect to MySQL via IP In reply to
thx!
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [carfac] Connect to MySQL via IP In reply to
Try connecting from shell and make sure the permissions are setup properly:

mysql -uUSERNAME -pPASSWORD -h123.123.123.123 DATABASE

Cheers,

Alex
--
Gossamer Threads Inc.