Re: MYSQL ERROR CONNECT

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 >