Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

www.xxx.con, linux raid 10 near far offset comparison, xxxCons.jsp, w2ksp4 download, linux mdadm use spare drive, www.xxxcon, wwwxxxx.ocB, www...xxxcon, wwwxxxxcoN, Wwwxxx.con

Links

XODOX
Impressum

#1: ODBC access denied in wampserver

Posted on 2010-06-21 12:20:38 by Jacob Kruger

------=_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--

Report this message

#2: Re: ODBC access denied in wampserver

Posted on 2010-06-21 12:47:46 by Pierre Joye

hi,

On Mon, Jun 21, 2010 at 12:20 PM, Jacob Kruger <jacobk@mailzone.co.za> 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

Report this message

#3: Re: ODBC access denied in wampserver

Posted on 2010-06-21 12:51:01 by Jacob Kruger

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" <pierre.php@gmail.com>
To: "Jacob Kruger" <jacobk@mailzone.co.za>
Cc: <php-windows@lists.php.net>
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 <jacobk@mailzone.co.za>
> 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

Report this message

#4: Re: ODBC access denied in wampserver

Posted on 2010-06-21 12:52:00 by Jacob Kruger

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

Stay well

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

----- Original Message -----
From: "Pierre Joye" <pierre.php@gmail.com>
To: "Jacob Kruger" <jacobk@mailzone.co.za>
Cc: <php-windows@lists.php.net>
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 <jacobk@mailzone.co.za>
> 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

Report this message

#5: Re: ODBC access denied in wampserver

Posted on 2010-06-21 13:11:31 by Jacob Kruger

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@publishingtechnology.com>
To: "'Jacob Kruger'" <jacobk@mailzone.co.za>
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

Report this message