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 danbr...@php.net wrote in message news:ab5568160906180636r239f214eh7e4871da7139c...@mail.gmail.com... On Thu, Jun 18, 2009 at 06:03, NADARAJAH SIVASUTHAN NADARAJAHnsivasut...@live.com 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 P. Brown 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 NADARAJAHnsivasut...@live.com 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
On Thu, Jun 18, 2009 at 06:03, NADARAJAH SIVASUTHAN NADARAJAHnsivasut...@live.com 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 P. Brown 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
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 -- html body ?php $db = mysql_connect(localhost, root,xx); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM employees,$db); printf(First Name: %sbr\n, mysql_result($result,0,first)); printf(Last Name: %sbr\n, mysql_result($result,0,last)); printf(Address: %sbr\n, mysql_result($result,0,address)); printf(Position: %sbr\n, mysql_result($result,0,position)); ? /body /html --- 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