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
[PHP-DB] PHP- Mysql problem
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
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
[PHP-DB] php-mysql problem
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
--
\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
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
[PHP-DB] PHP/MySQL Problem....
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
and line 3 looks like this.
$connection = mysql_connect("localhost", "mylogin", "mypass") or die
("Couldn't connect.");
Also my php configure command looks like this..
'./configure' 'i386-redhat-linux' '--prefix=/usr' '--exec-prefix=/usr'
'--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc'
'--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib'
'--libexecdir=/usr/libexec' '--localstatedir=/var'
'--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--prefix=/usr'
'--with-config-file-path=/etc' '--enable-force-cgi-redirect'
'--disable-debug' '--enable-pic' '--disable-rpath'
'--enable-inline-optimization' '--with-bz2' '--with-db3' '--with-curl'
'--with-dom=/usr' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr'
'--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-ttf'
'--with-gdbm' '--with-gettext' '--with-ncurses' '--with-gmp'
'--with-iconv' '--with-jpeg-dir=/usr' '--with-mm' '--with-openssl'
'--with-png' '--with-pspell' '--with-regex=system' '--with-xml'
'--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU'
'--enable-bcmath' '--enable-debugger' '--enable-exif' '--enable-ftp'
'--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets'
'--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path'
'--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx'
'--without-oci8' '--with-imap=shared' '--with-imap-ssl'
'--with-kerberos=/usr/kerberos' '--with-ldap=shared'
'--with-mysql=shared,/usr' '--with-pgsql=shared'
'--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack'
'--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath'
'--enable-shmop' '--enable-versioning' '--enable-calendar'
'--enable-dbx' '--enable-dio' '--enable-mbstring'
'--enable-mbstr-enc-trans' '--with-apxs=/usr/sbin/apxs'
Any help would be greatly appreciated.
-Grant
Grant P. Kohler
Technology Consultant
The Information Age, Inc.
[EMAIL PROTECTED]
770.838.0373
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
[PHP-DB] php/mysql problem
hi,
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...
Stefan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP+MySQL PROBLEM: mysql_fetch_fields mess?
Hi Everyone,
Is it just me, or something is BADLY wrong with some MySQL functions?
Is there some rule in which order to call mysql functions?
I made following routine:
");
return 0;
};
if(mysql_affected_rows()==0) {
echo('No data.');
return 0;
};
echo("");
echo("");
// First field and its value I show in different color
$meta = mysql_fetch_field ($data);
$data_row = mysql_fetch_array ($data);
// Here I want to get number of fields
$n = mysql_num_fields($data);
echo("$meta->name");
echo("$data_row[0]");
$i = 1;
// Now I show fields from index 1 to the last field
while ($i < $n) {
$meta = mysql_fetch_field($data);
echo("$meta->name$data_row[i]");
$i++;
};
echo("");
return 1;
};
?>
Table I tried to show has 7 fields; first row (first field) show OK, but the
rest ARE EMPTY!!!
I tried to change the order of functions or anything, but it seems that
after first acces of mysql_fetch_field something happens to $data_row?!?
Can someone explain this and help me work out with it?
TIA
Davor
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
