Re: [PHP-DB] PHP- Mysql problem
Daniel, Now that is just funny stuff... Have you tried http://lmgtfy.com/?q=access+denied+for+user+odbc+localhost or the newer http://www.lmbify.com/search.php?s=access+denied+for+user+odbc+localhost "Daniel Brown" wrote in message news:ab5568160906180636r239f214eh7e4871da7139c...@mail.gmail.com... > On Thu, Jun 18, 2009 at 06:03, NADARAJAH SIVASUTHAN > NADARAJAH wrote: >> >> Warning: mysql_query() [function.mysql-query]: Access denied for user >> 'ODBC'@'localhost' (using password: NO) in >> C:\wamp\www\ap_v5\inc\profile.inc.php on line 285 > > http://google.com/search?q=Access%20denied%20for%20user%20'ODBC'@'localhost'%20(using%20password:%20NO) > > http://fart.ly/dm6m7 > > -- > > daniel.br...@parasane.net || danbr...@php.net > http://www.parasane.net/ || http://www.pilotpig.net/ > 50% Off All Shared Hosting Plans at PilotPig: Use Coupon DOW1 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP- Mysql problem
On Thu, Jun 18, 2009 at 06:03, NADARAJAH SIVASUTHAN NADARAJAH wrote: > > Warning: mysql_query() [function.mysql-query]: Access denied for user > 'ODBC'@'localhost' (using password: NO) in > C:\wamp\www\ap_v5\inc\profile.inc.php on line 285 http://google.com/search?q=Access%20denied%20for%20user%20'ODBC'@'localhost'%20(using%20password:%20NO) http://fart.ly/dm6m7 -- daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ 50% Off All Shared Hosting Plans at PilotPig: Use Coupon DOW1 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP- Mysql problem
On Thu, Jun 18, 2009 at 6:03 AM, NADARAJAH SIVASUTHAN NADARAJAH wrote: > > > > Dear all, > > When I try to retrive data from two tables using JOIN OR INNER JOIN it > display error message > > given below; > > > > Warning: mysql_query() [function.mysql-query]: Access denied for user > 'ODBC'@'localhost' (using password: NO) in > C:\wamp\www\ap_v5\inc\profile.inc.php on line 285 > > Warning: mysql_query() [function.mysql-query]: A link to the server could not > be established in C:\wamp\www\ap_v5\inc\profile.inc.php on line 285 > > Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result > resource in C:\wamp\www\ap_v5\inc\profile.inc.php on line 288 > > > > > > what may be the reason? > > > > Normally PHP-mysql works fine. > > Can you figure it out and give me the possible solution? > > > > Thank you. > > suthan > > > > _ > Windows Live™: Keep your life in sync. Check it out! > http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_allup_explore_012009 The db user account that you are attempting the connection with does not have access to the db. Check the account details -- Bastien Cat, the other other white meat -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php-mysql problem
hello, did you load the mysql module in your php.ini configuration file? i.e. is the following line there: extension=mysql.so regards On Thu, 13 May 2004 11:47:41 -0400 Jianping Zhu <[EMAIL PROTECTED]> wrote: > have redhat 9.0 and Server version: Apache/2.0.40. > i have installed rpms php-4.2.2-17.2.i386.rpm >php-mysql-4.2.2-17.2.i386.rpm > > >After i create a database called mydb and serveral tables in mysql, >I tried to run following testdb.php script > > >-- > > >$db = mysql_connect("localhost", "root","xx"); >mysql_select_db("mydb",$db); >$result = mysql_query("SELECT * FROM employees",$db); >printf("First Name: %s\n", mysql_result($result,0,"first")); >printf("Last Name: %s\n", mysql_result($result,0,"last")); >printf("Address: %s\n", mysql_result($result,0,"address")); >printf("Position: %s\n", mysql_result($result,0,"position")); >?> > > >--- > >but i got error message with: >http://coopunit.forestry.uga.edu:8080/testdb.php >the error is: >Fatal error: Call to undefined function: >mysql_connect() in /var/www/html/testdb.php on line 13 > >How can Fix this problem? Thanks > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP/MySQL Problem....
On Friday 20 December 2002 00:56, Grant P. Kohler wrote: > Hello, > > I seem to have a problem getting my PHP to work with MySQL. > I have installed Redhat 7.3 on my system and I installed apache, php, > and mysql from the redhat install cd via the RPMS. Now I know the PHP > works just fine normally, but when I start trying to use the MySQL > commands in my PHP pages to connect to the database I start getting > fatal errors like the following. > > Fatal error: Call to undefined function: mysql_connect() in > /home/gkohler79/public_html/book1/chapter11/db_connect.php on line 3 If this is an all Redhat RPM installation then install the mysql-php*.rpm as well. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* If you suspect a man, don't employ him. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php/mysql problem
Hi Stefan, > i've a problem with php and mysql. > a mysql-server is running on my server on that i can access from 'outside'. > but, if i want to connect to the server with a 'local' php skript (running > on the same server), mysql refuses the login ('acces denied for user > [...]'). the problem is that the login i use in the php skript is exactly > the same as the one i use for connecting from 'outside'. > another strange thing is that the php skript can connect to other mysql-dbs > on other servers... > is it a config-problem ? i've no idea anymore... you@remotehost is not the same (MySQL user) as you@localhost! Check out the MySQL manual's page on user privileges and access control. Regards, =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php