I found a "solution." I uninstalled (and deleted the ini file) MySQL
v. 3.23.36 and installed v. 3.23.38 and now it works. I have no
idea why. But I learned some things in the process. Thank you
very much for all the help.
Jeff Oien
> Where you have your variable set to "password" just put "" that means there
> is no password other whys your saying your password is password
> ""Jeff Oien"" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I tried your code and got this:
> >
> > Warning: Can't connect to MySQL server on 'localhost'
> >
> > Also tried ip address of my machine. So at least maybe that narrows
> > down the problem.
> > Jeff Oien
> >
> > > 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]
> > >
> >
> > --
> > 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]
> >
>
>
>
> --
> 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]
>
--
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]
