RE: [PHP-DB] MySQL Connect Problem

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"" <jeff@webdesigns1.com> wrote in message > news:PGEBKOPJJHHICHGDKCCIAEALCHAA.jeff@webdesigns1.com... > > 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:jeff@webdesigns1.com] > > > 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: php-db-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-db-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >