Re: MySQL Connect Problem

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. ======================================================