No, you misunderstand. You have mysql_pconnect($hostname_storeunclesam, $username_storeunclesam, $password_storeunclesam)
but there is no value to the variables so what you are actually doing is mysql_pconnect( , , ) You need to define the variables before calling the function like so: $hostname_storeunclesam = 'localhost'; $username_storeunclesam = 'my_name'; $password_storeunclesam = 'my_pass'; BTW, you should NEVER put your password into the php.ini file. The sheer security risk in doing so is huge! Really a bad idea. Also, I do not recommend using pconnect as this establishes a permanent connection. This means even when the user leaves your site, your MySQL is STILL CONNECTED! It is much less resouce intensive just to use mysql_connect, as that way the connection is automatically closed when the php page is finished being made. Stephen Yes, I am right. Why? Because the error message says "Using password? No", which means you have provided no password. ----- Original Message ----- From: "Ildiko Nyari" <[EMAIL PROTECTED]> To: "Stephen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, June 20, 2003 10:30 PM Subject: Re: [PHP-WIN] Access denied for user: '[EMAIL PROTECTED]'. Dreamweaver MX > Thanks, > I have the username and password entered in mySQL for that specific table > and also in the php file at $username_storeunclesam .... so on, the same > username and password, however I have this ODBC issue. > > What else might be wrong? > > THANKS. > ildiko > > > > ----- Original Message ----- > From: "Stephen" <[EMAIL PROTECTED]> > To: "Ildiko Nyari" <[EMAIL PROTECTED]> > Cc: "Windows Helplist (PHP)" <[EMAIL PROTECTED]> > Sent: Friday, June 20, 2003 5:26 PM > Subject: Re: [PHP-WIN] Access denied for user: '[EMAIL PROTECTED]'. Dreamweaver > MX > > > > ODBC I believe is the default connection name when none is specified. You > > have the code mysql_pconnect($hostname_storeunclesam, > > $username_storeunclesam, $password_storeunclesam), but have you set a > value > > to all the variables? You need to set $username_storeunclesam and > > $password_storeunclesam to the username and password used for your MySQL > > account. > > > > Stephen > > > > P.S. This is very much a PHP issue, as it is to do with php connecting to > > MySQL rather than MySQL itself. "If you don't have something useful to > say, > > don't say anything!" > > > > ----- Original Message ----- > > From: "Ildiko Nyari" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, June 20, 2003 9:27 PM > > Subject: [PHP-WIN] Access denied for user: '[EMAIL PROTECTED]'. Dreamweaver > MX > > > > > > Does anybody have a clue about this? > > I get this error message: > > > > Warning: mysql_pconnect(): Access denied for user: '[EMAIL PROTECTED]' (Using > > password: NO) in C:\Program Files\Apache > > Group\Apache2\htdocs\www\Connections\storeunclesam.php on line 9 > > Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > > > > > and line 9 is: > > > > $storeunclesam = mysql_pconnect($hostname_storeunclesam, > > $username_storeunclesam, $password_storeunclesam) or die(mysql_error()); > > in the Connections file. > > > > Do you have any guess? > > thanks. > > > > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
