Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

RE: [PHP-DB] MySql From: Cal Evans (cal <email protected>)
Date: 01/03/01

Also, make sure the MySQL database CAN be accessed from another machine. A
lot of machines have this locked down to localhost or a specific IP address.
if that is the case, no amount of PHP code will access the database.

Can you use MySQL client on another machine to point to your database?

Cal

-----Original Message-----
From: gulinma <email protected> [mailto:gulinma <email protected>]On Behalf Of
Marcelo Gulin
Sent: Wednesday, January 03, 2001 11:55 AM
To: Jayme Derr
Cc: php-db <email protected>
Subject: Re: [PHP-DB] MySql

Hi Jayme!

you must use..

<?
  $opendb = mysql_pconnect( "your_host_address:port","your_user",
"your_password" );
  $selectdb = mysql_select_db("your_database");
?>

hope it helps you
Marcelo Gulin

Jayme Derr escribió:
>
> I do not understand how to connect to a MySql
> database. The MySql database is on a separate
> machine. I have used telnet to reach the db, so I
> know it is there. Problem. I have a user name and
> password to get on the machine, and then I type a
> command in to actually see the MySql db. Before I see
> the mysql prompt, I have to type in a separate
> password. What command in PHP should I use? I am
> assuming I use mysql_connect, but isn't this just to
> connect to the machine? How do I connect to the
> database with the different password?
>
> Thanks,
> Jayme Derr
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos - Share your holiday photos online!
> http://photos.yahoo.com/
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected> 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>