Re: MySQL and phpMyAdmin

[Gleb Paharenko]

Hello.



I think you should rebuild php with the 4.1.10 libraries.

Search in the archives at 



  http://lists.mysql.com/mysql



about successful solution for similar problem(s). See:



  http://dev.mysql.com/doc/mysql/en/old-client.html







Asad Habib <[EMAIL PROTECTED]> wrote:

> I just installed phpMyAdmin, made the appropriate changes in the

> config.inc.php file, and got the following error when accessing it via

> both IE and Safari on Mac OS X Panther client.

> 

> #1251 - Client does not support authentication protocol requested by

> server; consider upgrading MySQL client

> 

> I am using MySQL 4.1.10, the latest stable release, with

> phpMyAdmin-2.6.1-pl3, which the documentation says are compatible. Any

> help would be greatly appreciated. Thanks.

> 

> - Asad

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL and phpMyAdmin

[Karam Chand]

Even I had the same problem so I moved to using SQLyog
and its an awesom client.

http://www.webyog.com

Karam
--- Asad Habib <[EMAIL PROTECTED]> wrote:
> I just installed phpMyAdmin, made the appropriate
> changes in the
> config.inc.php file, and got the following error
> when accessing it via
> both IE and Safari on Mac OS X Panther client.
> 
> #1251 - Client does not support authentication
> protocol requested by
> server; consider upgrading MySQL client
> 
> I am using MySQL 4.1.10, the latest stable release,
> with
> phpMyAdmin-2.6.1-pl3, which the documentation says
> are compatible. Any
> help would be greatly appreciated. Thanks.
> 
> - Asad
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL and phpMyAdmin

[Michael Stassen]

Did you try searching on the error message first?  I got hundreds of hits in 
Google for this.  Searching the mysql docs, the first hit 
 has the explanation.

The short version is that password security has been improved in mysql 4.1, 
so clients need to be compiled against a 4.1 mysql client library to work. 
Your copy of php, however, is compiled against an older version of the 
client library (probably 3.23).

You can tell mysql to accept old-style passwords (details in the 
documentation linked above)for one or all users, but the better solution is 
to fix your copy of php, either by installing a php package pre-compiled 
against the newer client library, or by building php from source yourself 
using your copy of the mysql client library.  Either way, you can find 
directions at the php site and elsewhere.

Michael
Asad Habib wrote:
I just installed phpMyAdmin, made the appropriate changes in the
config.inc.php file, and got the following error when accessing it via
both IE and Safari on Mac OS X Panther client.
#1251 - Client does not support authentication protocol requested by
server; consider upgrading MySQL client
I am using MySQL 4.1.10, the latest stable release, with
phpMyAdmin-2.6.1-pl3, which the documentation says are compatible. Any
help would be greatly appreciated. Thanks.
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql and PHPMYadmin

[Barry Zimmerman]

Quick question if anyone can help.

I was reading through the manual and it states something about the character
sets being different from mysql version 4 to version 4.1.1

We have just upgraded from 4 to version 4.1.1 and are having problems with
accent characters on our database table. Some fields import with the correct
characters yet the one field called description of type TEXT does not insert
with the characters instead it puts a ? in its place.

Could the effect of this from the manual:
-
Finally, there is a different file format for storing information about
character sets and collations. Make sure that you have reinstalled the
Œ/share/mysql/charsets/¹ directory
containing the new configuration files.
--

Cause this to happen?

Please help.

Thanks


Barry
--
Barry Zimmerman
Administrator

Fishingvenues.com
http://www.fishingvenues.com
--

> From: Victor Pendleton <[EMAIL PROTECTED]>
> Date: Mon, 2 Aug 2004 13:46:02 -0500
> To: "'Barry Zimmerman '" <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '"
> <[EMAIL PROTECTED]>
> Subject: RE: Mysql and PHPMYadmin
> 
> Do you know the ASCII values for the characters that are being turned into
> question marks? Are you able to verify that the data is not be imported by
> querying the underlying ascii value?
> 
> -Original Message-
> From: Barry Zimmerman
> To: [EMAIL PROTECTED]
> Sent: 8/2/04 1:00 PM
> Subject: Mysql and PHPMYadmin
> 
> Hi,
> 
> Hoping that someone can help me, as I have tried everywhere for help and
> still cannot get this to work.
> 
> I am using MySQL 4.1.1
> 
> I have a sql file that contains french accent characters. I have 8
> fields in
> my database. Now the content of the text file imports into my database,
> when
> I import the text into the database some fields enter the accent
> characters
> correctly and others do not.
> 
> The field type varchar imports the text no problem.
> 
> The field type text does not, it converts my accents into ? and does not
> import them.
> 
> I have tried to change the character sets and this also does not work.
> Does
> anyone know how I can solve this problem. Also what is the correct
> character
> set and collation for french characters.
> 
> Please could someone help.
> 
> Thanks
> 
> Barry
> --
> Barry Zimmerman
> Administrator
> 
> Fishingvenues.com
> http://www.fishingvenues.com
> --
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Mysql and PHPMYadmin

[Victor Pendleton]

Do you know the ASCII values for the characters that are being turned into
question marks? Are you able to verify that the data is not be imported by
querying the underlying ascii value? 

-Original Message-
From: Barry Zimmerman
To: [EMAIL PROTECTED]
Sent: 8/2/04 1:00 PM
Subject: Mysql and PHPMYadmin

Hi,

Hoping that someone can help me, as I have tried everywhere for help and
still cannot get this to work.

I am using MySQL 4.1.1

I have a sql file that contains french accent characters. I have 8
fields in
my database. Now the content of the text file imports into my database,
when
I import the text into the database some fields enter the accent
characters
correctly and others do not.

The field type varchar imports the text no problem.

The field type text does not, it converts my accents into ? and does not
import them.

I have tried to change the character sets and this also does not work.
Does
anyone know how I can solve this problem. Also what is the correct
character
set and collation for french characters.

Please could someone help.

Thanks

Barry
--
Barry Zimmerman
Administrator

Fishingvenues.com
http://www.fishingvenues.com
--


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]