[PHP] MYSQL ERROR CONNECT

2002-05-06 Thread Dani 

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

Re: [PHP] MYSQL ERROR CONNECT

2002-05-06 Thread The_RadiX 

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

Re: [PHP] MYSQL ERROR CONNECT

2002-05-06 Thread Dani 

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
 :  [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

RE: [PHP] MYSQL ERROR CONNECT

2002-05-06 Thread John Holmes 

 Warning: Access denied for user: 'nobody@localhost' (Using password:
NO)
 in /www/host/doms/com/smpk2/create_tables.php on line 15

Hmm...let me see if I can decrypt that message. Apparently you were
denied access with user nobody and you were not using a password.

Read the manual page on mysql_connect(), you're missing some arguments.

---John Holmes...


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php