okay.. i'm stumped. what client libraries?
using php 5, so is it php_mysql.dll???
i'm using a canned script, so i have to make the changes there too?
i checked out the mysql help link. i even started the mysqld with the
--old-passwords parameter...
still getting the error...
thanks...
Bastien
Check the mysql website. Have you upgraded from 4.0x to 4.1 recently. If so
you need to update the client libraries that come with mysql. There are
significant protocol changes from 4.0x to 4.1.
Bastien
From: ian [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject:
ian wrote:
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
http://dev.mysql.com/doc/mysql/en/Old_client.html
--
PHP Database Mailing List
thnx ya'll... :)
On Mon, 2004-11-08 at 17:52, Bastien Koert wrote:
Check the mysql website. Have you upgraded from 4.0x to 4.1 recently. If so
you need to update the client libraries that come with mysql. There are
significant protocol changes from 4.0x to 4.1.
Bastien
From: ian
If the threadID column is an int, you don't need to wrap the $threadID
variable in quotes.
HTH ~randy
On Tue, 14 Sep 2004 00:05:56 +0200, -{ Rene Brehmer }-
[EMAIL PROTECTED] wrote:
hi gang
I'm working on optimizing the SQL for my forum system, but have run into a
problem trying to optimize
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
Hello Mark,
I have tryed it by splitting the file into pices and then insert it with the
help of phpmyadmin. This woked.
however, I do have some more files to upload, and this seems to be not the
fastest way:-)
I tryed this:
You could use mysqlimport with --fields-terminated-by=;
or you could open it in something like Excel, parse it there (text to
columns), and save it as a CSV
or you could read it line by, line into PHP, explode each line on the
;, then insert the data into MySQL
or you could write a
Thanks for all the help everyone sent me on this. However, nothing seems to
make any difference whatsoever (except putting the 'localhost' part in
quotes). I am still getting permission denied errors based on the user
credentials.
I have entered a user into the user table with host='localhost',
On Fri, 14 Feb 2003 11:30:03 +0200
[EMAIL PROTECTED] (Evan Morris) wrote:
Thanks for all the help everyone sent me on this. However, nothing
seems to make any difference whatsoever (except putting the
'localhost' part in quotes). I am still getting permission denied
errors based on the user
Looks like is to do with MySQL permissions. Check your host's (the one you
are trying to connect from) permissions to the server.
To change permissions, from the MySQL prompt type;
GRANT ALL ON * TO username@host IDENTIFIED BY password;
Substitute in username, host and password for your ones.
:[EMAIL PROTECTED]]
Sent: 13 February 2003 14:01
To: Clarkson, Nick
Subject: Re: [PHP-DB] MySQL problem -- new to PHP
Well you opened up my question! Do you know where to learn PHPMyAdmin?
Thanks in advance,
Mark
Clarkson, Nick wrote:
Looks like is to do with MySQL permissions. Check your host's
If you cut and pasted your code, try to put localhost into quotes as well.
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:
When changing/adding permissions to the mysql db for specific users,
dont forget to do 'flush privileges'...
my 2 cents
On Thu, 2003-02-13 at 07:19, Evan Morris wrote:
Hi all
I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.
Hi
you need quotes around the values
mysql_query(insert into tblquotehits
(qoption,referer,browser,remoteaddr,dt) values
('$quotetype','$referer','$browser','$remoteaddress','$currentdtstring'),$d
b);
HTH
Peter
---
Excellence in internet and open
So what's the problem? The data doesn't appear in the table? Did you try
to see if mysql_error() had anything in it after your query?
---John Holmes...
-Original Message-
From: Bill Arbuckle, Jr. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 28, 2002 5:56 PM
To: [EMAIL
Maybe I'm missing something - but the MySQL statement looks right ...
How are you displaying the results?
-Original Message-
From: Griffiths, Daniel [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2002 16:37
To: PHP List
Subject: [PHP-DB] MySQL Problem
Hi,
I have a problem with an MySQL
: 21 November 2002 16:41
To: Griffiths, Daniel; PHP List
Subject: RE: [PHP-DB] MySQL Problem
Maybe I'm missing something - but the MySQL statement looks right ...
How are you displaying the results?
-Original Message-
From: Griffiths, Daniel [mailto:[EMAIL PROTECTED]]
Sent: 21 November
Still think we need to see the PHP code before determining that it is an SQL
problem.
Regards,
J
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21, 2002 11:55 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Problem
On Friday 22 November
the month starts at 1, at the moment I'm just hard coding the month into the statment.
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2002 16:55
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Problem
On Friday 22 November 2002 00:46, Griffiths
Woo-hoo! Fixing the extensions directory worked. I am now all set with MySQL
support ... Thanks for all the help!
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Saturday 08 June 2002 05:29, Garrett Nelson wrote:
I now downloaded php-mysql-4.1.2-1a.ppc.rpm from rpmfinder, and again I
get
rpm -ivh php-mysql*
Preparing...###
[100%]
package php-mysql-4.1.2-1a is already installed
(Same error
On Saturday 08 June 2002 23:20, Garrett Nelson wrote:
I have both the lines in httpd.conf. As I said, PHP is working fine, it's
just an issue with MySQL support I believe.
Sorry my mistake. Check in php.ini for this line:
extension=mysql.so
--
Jason Wong - Gremlins Associates -
On Sunday 09 June 2002 01:28, Garrett Nelson wrote:
Well, we're getting closer now, maybe. I added the line extension=mysql.so,
and I still get the same error when trying to run the web-based PHP apps,
but in the command line when I type php I get back,
PHP Warning: Unable to load dynamic
On 6/6/02 4:48 PM, Jason Wong [EMAIL PROTECTED] wrote:
On Friday 07 June 2002 04:36, Garrett Nelson wrote:
I'm a relative newbie to the Linux/web server world, having worked with
Macs most of my life. I recently installed the Server install of Yellow Dog
Linux, with no window managers, CLI
on 6/6/02 4:36 PM, Garrett Nelson at [EMAIL PROTECTED] appended the
following bits to my mbox:
What needs to be configured? I was under the impression that MySQL support
was built into PHP now and that it needs no extension. I downloaded the RPM
of PHP 4.1.2 (the latest PPC RPM available at
That means PHP is not compiled with the MySQL support... Configure it with
mysql support, I bbelieve there were a lot of questions about this in the
list, so you may wanna search the archives..
Gurhan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
On Fri, 2002-02-22 at 09:37, Caleb Walker wrote:
I keep on getting this error statement:
Warning: Supplied argument is not a valid MySQL result resource in
/usr/local/www/data/phone/insert2.php on line 10
2
Can someone tell me what is wrong with the code below, I just cannot figure
it
I did change the id fields from TINYINT to INT (that was just a careless
error), and fixed something else. But I still have the same problems. The
new table schemas are below, along with the queries that don't work.
I'd love for someone to reproduce the error. As a possible workaround,
("DocCountry", "INSERT INTO files (idProject, name,
comment) VALUES (0, 'sysmsg9.txt', 'Some file')");
}
else echo("Connection failed");
-Mensagem Original-
De: Chris [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: tera-feira, 6 de maro de 2001 16:13
Assunto: R
Have you put an echo with mysql_error() after performing each query ?
Jayme.
-Mensagem Original-
De: Chris [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: segunda-feira, 5 de maro de 2001 05:04
Assunto: [PHP-DB] MySQL - Problem with multiple INSERTs?
Howdy,
I'm getting weird
30 matches
Mail list logo
