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
: [EMAIL PROTECTED]
: ABN: 64 235 749 494
: QUT Student #: 04475739
:::::::::::::::::::::::::::::::::::::::::::
----- Original Message -----
From: "Dani" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
