Hi Jeff,
I am using Windows, but am a beginner.  Here is some code I use maybe it
will help

I use this in my navigation pages:

<? include ("db_details.php"); ?>

<?

mysql_pconnect("$host","$user","$password")
or die("Unable to connect to SQL server");
mysql_select_db("$dbasename") or die("Unable to select database");
?>

and here is db_details.php

<?
$host="host.name.com";
$user="user_id";
$password="password";
$dbasename="database_name";
?>
By using the include it means if I go LIVE with a site I only have to change
one file db_details.php
The reason I don't do it all in one is that it didn't like "." in IP
addresses for some reason ( I think it thought it was the beginning of a
string)
On my windows machine my db_details would look like this
<?
$host="localhost";
$user="";
$password="";
$dbasename="database_name";
?>
You shouldn't need a password.
I hope this helps
All the Best
Lisa

-----Original Message-----
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 2:16 PM
To: PHP-DB
Subject: RE: [PHP-DB] MySQL Connect Problem


I'm on Windows 2000.
Jeff

> Jeff,
> 
> If you are on unix/linux use the command id to see who you are.
> You can only use jeff in your connect string if jeff is a user in your
mysql 
> database. 
> 
> If you are root when you are running mysql then you should probably set a 
> password for root in the database.
> 
> Wayne
> 
> 
> On Thu, 17 May 2001 13:20, Jeff Oien wrote:
> > > > Here is sample code:
> > > > <?
> > > > $connection = @mysql_connect("localhost", "jeff", "*****")
> > > > or die("Couldn't connect.");
> > > > if ($connection) {
> > > > $msg = "success!";
> > > > }
> > > > ?>
> > > >
> > > > This is on my machine only used by me. I also tried connecting to
> > > > IP address and 127.0.0.1 and it still won't work. Thanks.
> > > > Jeff Oien
> > >
> > > Are your the 'root' rather than 'jeff'?  Did you alter the grants and
> > > apply the password? If not do you need  a password for connection?
> > >
> > > Tim Morris
> >
> > To be honest I don't know if I am root. I know I don't need a password
> > to connect via the command line. I just type 'mysql'. I do have username
> > and password specified in the .ini file which I believe I set when I
first
> > installed it. What can I do from here?
> > Jeff Oien
> 
> -- 
> Wayne Bastow - DBA - Central Coast Health Phone: 61 2 43203231
> Email: wbastowATccahsDOThealthDOTnswDOTgovDOTau
>  
> Linux, the choice of a GNU generation Kernel 2.2.16-22 on a i686
>  
> Running Windows on a Pentium is like having a brand new Porsche but  only 
> be able to drive backwards with the handbrake on. (Unknown source)
> 
> ======================================================
> This message is intended for the addressee named and may contain 
> confidential information. If you are not the intended recipient, please 
> delete it and notify the sender. Views expressed in this message are 
> those of the individual sender, and are not necessarily the views of 
> the NSW Department of Health.
> ======================================================
> 

-- 
PHP Database 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]

Reply via email to