Re: Access denied for user: 'ODBC@127.0.0.1'. 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" <stephen.edmonds5@btinternet.com> To: "Ildiko Nyari" <ildiko.nyari@earthlink.net> Cc: "Windows Helplist (PHP)" <php-windows@lists.php.net> Sent: Friday, June 20, 2003 5:37 PM Subject: Re: [PHP-WIN] Access denied for user: 'ODBC@127.0.0.1'. 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" <ildiko.nyari@earthlink.net> > To: "Stephen" <stephen.edmonds5@btinternet.com> > Cc: <php-windows@lists.php.net> > Sent: Friday, June 20, 2003 10:30 PM > Subject: Re: [PHP-WIN] Access denied for user: 'ODBC@127.0.0.1'. 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" <stephen.edmonds5@btinternet.com> > > To: "Ildiko Nyari" <ildiko.nyari@earthlink.net> > > Cc: "Windows Helplist (PHP)" <php-windows@lists.php.net> > > Sent: Friday, June 20, 2003 5:26 PM > > Subject: Re: [PHP-WIN] Access denied for user: 'ODBC@127.0.0.1'. > 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" <ildiko.nyari@earthlink.net> > > > To: <php-windows@lists.php.net> > > > Sent: Friday, June 20, 2003 9:27 PM > > > Subject: [PHP-WIN] Access denied for user: 'ODBC@127.0.0.1'. Dreamweaver > > MX > > > > > > > > > Does anybody have a clue about this? > > > I get this error message: > > > > > > Warning: mysql_pconnect(): Access denied for user: 'ODBC@127.0.0.1' > (Using > > > password: NO) in C:\Program Files\Apache > > > Group\Apache2\htdocs\www\Connections\storeunclesam.php on line 9 > > > Access denied for user: 'ODBC@127.0.0.1' (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 > > > > > >