Re: MYSQL ERROR CONNECT

Thanks radix! I'm new to PHP that's why.. so, what should I do to fix this? please advise.. thanks again. Dani The_RadiX wrote: > Ha.. Aussie person too eh? > > Ok.. Have you recently updated your php system? > > Reason I ask is the way you are using the functions mysql_connect and > mysql_select_db are quite ... "bad" to say the least > > You should have permissions setup for a root account or something in your > mysql.user table and then you can do this: > > $DB=mysql_connect("localhost","root","password"); > > notice I now have a user/pass arg and also I am assigning the handle of the > connection to a var ($DB) > > then use: > > mysql_select_db("smpk2",$DB); > > and that should work fine as long as user and pass are right and db exists.. > (and server has mysql running of course :P ) > > if not.. let us know.. > > If you want to know how to setup users and permissions for MySQL.. give us a > yell.. be glad to help out.. > > ::::::::::::::::::::::::::::::::::::::::::: > : Julien Bonastre [The-Spectrum.org CEO] > : A.K.A. The_RadiX > : the_radix@hotkey.net.au > : ABN: 64 235 749 494 > : QUT Student #: 04475739 > ::::::::::::::::::::::::::::::::::::::::::: > ----- Original Message ----- > From: "Dani" <universal2001@iprimus.com.au> > To: <php-general@lists.php.net> > Sent: Monday, May 06, 2002 11:49 PM > Subject: [PHP] MYSQL ERROR CONNECT > > > Hi, > > I have been using this code for while: > > > > //1. CONNECT TO DATABASE > > mysql_connect("localhost"); > > > > //2. SELECT A DATABASE > > mysql_select_db("smpk2"); > > > > to connect to MYSQL database. > > > > but I get this error: > > > > Warning: Access denied for user: 'nobody@localhost' (Using password: NO) > > in /www/host/doms/com/smpk2/create_tables.php on line 15 > > > > Warning: MySQL Connection Failed: Access denied for user: > > 'nobody@localhost' (Using password: NO) in > > /www/host/doms/com/smpk2/create_tables.php on line 15 > > > > could someone help me, please??? > > > > thanks > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > >