Dreamweaver uses pconnect by default, so if you want to use the more standard connect, just delete the p from the code! More can be found at
http://uk.php.net/manual/en/function.mysql-connect.php I suggest using the manual whenever you have a problem. At first, it might seem quite confusing but once you get used to it theres a lot of helpful information waiting to be found! Stephen ----- Original Message ----- From: "Ildiko Nyari" <[EMAIL PROTECTED]> To: "Stephen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, June 20, 2003 10:57 PM Subject: Re: [PHP-WIN] Access denied for user: '[EMAIL PROTECTED]'. Dreamweaver MX > Thank you. > > I have entered the variables and seems to be OK. > THANKS. > > Why do you think that I have put the put the password into the php.ini file? > And where can I define the type of connection? I just sad make mysql > connection, and it was created as pconnect. How do I make mysql_connect? > Where? > > THANKS. > > I would like to understand it. > ildiko > > > ----- Original Message ----- > From: "Stephen" <[EMAIL PROTECTED]> > To: "Ildiko Nyari" <[EMAIL PROTECTED]> > Cc: "Windows Helplist (PHP)" <[EMAIL PROTECTED]> > Sent: Friday, June 20, 2003 5:37 PM > Subject: Re: [PHP-WIN] Access denied for user: '[EMAIL PROTECTED]'. Dreamweaver > MX > > > > 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
