NuSphere Forums Forum Index
NuSphere Forums
Reply to topic
cant connect to db


Joined: 16 Feb 2004
Posts: 1
Location: kc
Reply with quote
I am using windows XP and PHPed to try to connect to my linux webhost & MySql server...

PHP Just locks up when i try

Can anyone help???
View user's profileFind all posts by gerrySend private message
cant connect to db


Joined: 16 Feb 2004
Posts: 2
Reply with quote
Are you connecting to local or remote mySQL server?

If remote you need to have permission to connect from your local box or from IP that you currently using.

Hope this helps. Cool
View user's profileFind all posts by new_boySend private message
Site Admin

Joined: 13 Jul 2003
Posts: 8344
Reply with quote
Yep, as stated by new_boy, you'll have to GRANT appropriate rights for incoming user (see GRANT syntax in mysql manual) and check firewall settings to allow incoming connections on TCP/3306.
Alternatively you can forward socket through ssh tunnel for example
ssh -L 3306:localhost:3306 username@linuxhost
In this case you'd set localhost as host name for mysql account.
View user's profileFind all posts by dmitriSend private messageVisit poster's website
cant connect to db
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 5 Hours  
Page 1 of 1  

  
  
 Reply to topic