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" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > 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: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
> > > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]