If this is the case, you need to check the rights that your id "jeff" has. It
should be in the mysql database under the tablename user. You have to make sure
that you have all the rights, all the priviliges equals to 'Y'. I'm not really
sure how these previiliges, but you can just set everything to 'Y' for the time
being, until you find what each and single one of those priviliges will do.
Do you have still have the "root" id? Have you tried to connect using the "root"
id?
If the command line is a hassle to you might want to try and download mysqlfront
from www.mysqlfront.de
Jeff Oien wrote:
> 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]
