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
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
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
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 Pieda
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
5 matches
Mail list logo
