The following lines set variable values:
$mySQLServer = "localhost";
$mySQLUsername = "root";
$mySQLPassword = "root";
The following line then tries to connect:
$con = mysql_connect($mySQLServer,$mySQLUsername, $mySQLPassword);
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
----- Original Message -----
From: "George Pitcher" <george.pitcher@xxxxxxxxxxxxxxxxxxxxxxxx>
To: "'Jacob Kruger'" <jacobk@xxxxxxxxxxxxxx>
Sent: Monday, June 21, 2010 12:42 PM
Subject: RE: ODBC access denied in wampserver
Jacob,
The comment (using password: NO) is telling you that no password is being
presented to MySQL.
Check your script where the password is entered into the login script.
Cheers
George
-----Original Message-----
From: Jacob Kruger [mailto:jacobk@xxxxxxxxxxxxxx]
Sent: 21 June 2010 11:21
To: php-windows@xxxxxxxxxxxxx
Subject: ODBC access denied in wampserver
Access denied for user 'ODBC'@'localhost' (using password: NO) in
C:\wamp\www\spiraleye\sql.php on line 9
(Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link
resource in C:\wamp\www\spiraleye\sql.php on line 15
Line 9 is the following:
$con = mysql_connect($mySQLServer,$mySQLUsername, $mySQLPassword);
Line 15 is the following:
mysql_select_db($mySQLDB, $con);
I initially had this issue while trying to connect with the default, blank
password for user, root, but now set the password to something else using
phpmyadmin, and it works via mysql-front, but still gives me the same
error/issue when trying to access the database via a PHP page?
Any thoughts?
TIA
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
__________ Information from ESET NOD32 Antivirus, version of virus
signature
database 5213 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 5213 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature database 5214 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
