ODBC access denied in wampserver

------=_NextPart_000_002B_01CB113C.28920800
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 =3D 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 signatur=
e database 5213 (20100621) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


------=_NextPart_000_002B_01CB113C.28920800--

Re: ODBC access denied in wampserver

hi,

On Mon, Jun 21, 2010 at 12:20 PM, Jacob Kruger wrote:
> 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

The use called "ODBC" has no access to the mysql database. Check the
mysql manual to know how to create new users or give existing users
the correct permissions.

Cheers,
--
Pierre

@pierrejoye | http://blog.thepimp.net | http://www.libgd.org

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

Re: ODBC access denied in wampserver

I am actually using the root user, and via MySQL-Front, it has rights to
create structures, etc., so I think it's more to do with a setting of
another type...?

Stay well

Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'

----- Original Message -----
From: "Pierre Joye"
To: "Jacob Kruger"
Cc:
Sent: Monday, June 21, 2010 12:47 PM
Subject: Re: [PHP-WIN] ODBC access denied in wampserver


> hi,
>
> On Mon, Jun 21, 2010 at 12:20 PM, Jacob Kruger
> wrote:
>> 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
>
> The use called "ODBC" has no access to the mysql database. Check the
> mysql manual to know how to create new users or give existing users
> the correct permissions.
>
> Cheers,
> --
> Pierre
>
> @pierrejoye | http://blog.thepimp.net | http://www.libgd.org
>
> __________ 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




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

Re: ODBC access denied in wampserver

Will try creating another user as well, but PHPMyAdmin isn't too great when
used with a screenreader

Stay well

Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'

----- Original Message -----
From: "Pierre Joye"
To: "Jacob Kruger"
Cc:
Sent: Monday, June 21, 2010 12:47 PM
Subject: Re: [PHP-WIN] ODBC access denied in wampserver


> hi,
>
> On Mon, Jun 21, 2010 at 12:20 PM, Jacob Kruger
> wrote:
>> 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
>
> The use called "ODBC" has no access to the mysql database. Check the
> mysql manual to know how to create new users or give existing users
> the correct permissions.
>
> Cheers,
> --
> Pierre
>
> @pierrejoye | http://blog.thepimp.net | http://www.libgd.org
>
> __________ 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




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

Re: ODBC access denied in wampserver

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"
To: "'Jacob Kruger'"
Sent: Monday, June 21, 2010 12:42 PM
Subject: RE: [PHP-WIN] 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@mailzone.co.za]
> Sent: 21 June 2010 11:21
> To: php-windows@lists.php.net
> Subject: [PHP-WIN] 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