Re: 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 script on this server, (mysql_connect("server1",user,password)) all that happens is that it still connects to the mysql in Server2 and not in Server1. I really cannot understand why. Being able to access Server1 using Server2 mysql command verifies my access rights right? I am about to give up on this! Thanks, Floyd almir wrote: > 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" <piedad@akasia.com> schrieb im Newsbeitrag > news:3AB80A08.AFAF082C@akasia.com... > > 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 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 Piedad" <piedad@akasia.com> schrieb im Newsbeitrag > > > news:3AB764B6.C4B8713A@akasia.com... > > > > 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 error logs do I examine to help me out - the one on the > > > local > > > > machine or on the remote machine? > > > > 4. And where is the mySQL error logs anyway? > > > > > > > > I tried other lists but no help there. I hope this list helps! > > > > > > > > Thanks all, > > > > > > > > Floyd Piedad > > > > > > > > > > > > -- > > > > PHP General Mailing List (http://www.php.net/) > > > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > > > For additional commands, e-mail: php-general-help@lists.php.net > > > > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-general-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net