ODBC access denied in wampserver
in [Windows]
|
From: "Jacob Kruger" on 21 Jun 2010 06:20 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
From: Pierre Joye on 21 Jun 2010 06:47 hi, On Mon, Jun 21, 2010 at 12:20 PM, Jacob Kruger <jacobk(a)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
From: "Jacob Kruger" on 21 Jun 2010 06:51 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(a)gmail.com> To: "Jacob Kruger" <jacobk(a)mailzone.co.za> Cc: <php-windows(a)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(a)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
From: "Jacob Kruger" on 21 Jun 2010 06:52 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(a)gmail.com> To: "Jacob Kruger" <jacobk(a)mailzone.co.za> Cc: <php-windows(a)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(a)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
From: "Jacob Kruger" on 21 Jun 2010 07:11 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(a)publishingtechnology.com> To: "'Jacob Kruger'" <jacobk(a)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(a)mailzone.co.za] > Sent: 21 June 2010 11:21 > To: php-windows(a)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
|
Pages: 1 Prev: Still having a hard time transferring records table to table Next: Next issue |