Re: [PHP] Problems connecting to remote mySQL server

the only problem could be that yourUser@webhost do not have same permisions for this db as yourUser@yourHost, check them if you can -almir "Floyd Piedad" [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi Almir, Yes I checked the names and they are

Re: [PHP] Problems connecting to remote mySQL server

Hi Almir, Here is more info: Server1: where my database resides Server2: where my script resides On Server1: I can access the database using mysql command and PHP. On Server2: I can access the database using mysql -hserver1 I can show all the tables, select data, etc. BUT, when running

[PHP] Problems connecting to remote mySQL server

I am trying to connect to a remote mySQL server through PHP but I get a mySQL error of "Unknown Database". I can connect to the remote mySQL server using the mysql command but not with PHP. 1. How can I debug what the problem is? 2. Do I need to specify the Port parameter in PHP? 3. Which mySQL

Re: [PHP] Problems connecting to remote mySQL server

when you connect to server issue "show databases" -query then look inside what you can see some servers are case sensitive i hope that will help, and are you sure that you are connected , it could be that you may not connect at all because of firewalls or something like that -almir "Floyd

Re: [PHP] Problems connecting to remote mySQL server

Hi Almir, Yes I checked the names and they are correct. Yes I am able to connect using the command prompt from the remote server as I am able to list the databases, tables, etc. remotely. Thanks, Floyd almir wrote: when you connect to server issue "show databases" -query then look inside