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...
Bas
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: ia
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 (h
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: [PH
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 opt
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 script tha
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
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:
mysql> LOAD DATA INFILE 'Hotel_Description.txt'INTO TABLE
test.hot
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 use
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', us
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 databa
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:
k Loewenberg [mailto:[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 permiss
Should have added; You don't have to GRANT ALL, obviously you can assign
permissions as required so you could just do GRANT SELECT, UPDATE if that is
all that is required.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2003 13:20
To: [EMAIL PROTECT
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.
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 PROTE
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
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, Grif
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
On Friday 22 November 2002 00:46, Griffiths, Daniel wrote:
> the statement runs without errors, its just the output thats wrong (see the
> two tables) I'm displaying the results by doing a simple dump of the query,
> through my own code and have also tried through phpMyAdmin.
Not sure if this coul
Sent: 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: 2
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 s
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 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 d
On 6/8/02 12:07 PM, "Jason Wong" <[EMAIL PROTECTED]> wrote:
> 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:
>
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 -> www.greml
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.
On 6/8/02 2:24 AM, "Jason Wong" <[EMAIL PROTECTED]> wrote:
> On Saturday 08 June 2002 05:29, Garrett Nelson wrote:
>> I now downloaded "php-mysql-4.1.2-1a.ppc.rpm" from rpmfinde
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
>
> (
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 manag
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 only. Everything is working pretty much
> correctly, exc
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, Ma
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
;
mysql_db_query("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]>
En
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,
everyth
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 março de 2001 05:04
Assunto: [PHP-DB] MySQL - Problem with multiple INSERTs?
> Howdy,
>
> I'm gettin
Addressed to: Chris <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from Chris <[EMAIL PROTECTED]> Mon, 05 Mar 2001 02:04:28 -0600
The first thing that jumps out is using tinyint for keys. Are you sure
there will never be more than 127 entries in the table?
I usually use b
37 matches
Mail list logo