RE: MySQL 5 / phpMyAdmin
try a search for old_password -Original Message- From: Amer Neely [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 10, 2006 1:39 PM To: MySQL List Subject: MySQL 5 / phpMyAdmin I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin 2.8.0.3 is now giving me grief. It gives me this error: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client I'm using the same phpMyAdmin config file as when I had a previous version of MySQL installed, so I'm stumped on what could be the hangup. How do I upgrade my MySQL client? phpinfo tells me the API is 3.23.49. $cfg['Servers'][$i]['auth_type'] = 'config'; I'm not even sure this is a MySQL question, but if someone can provide a clue for me that would be great. -- Amer Neely Home of Spam Catcher W: www.softouch.on.ca E: [EMAIL PROTECTED] Perl | MySQL | CGI programming for all data entry forms. We make web sites work! -- 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 5 / phpMyAdmin
Have a loot on this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html Regards! -Mensaje original- De: Amer Neely [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 10 de Mayo de 2006 12:39 p.m. Para: MySQL List Asunto: MySQL 5 / phpMyAdmin I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin 2.8.0.3 is now giving me grief. It gives me this error: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client I'm using the same phpMyAdmin config file as when I had a previous version of MySQL installed, so I'm stumped on what could be the hangup. How do I upgrade my MySQL client? phpinfo tells me the API is 3.23.49. $cfg['Servers'][$i]['auth_type'] = 'config'; I'm not even sure this is a MySQL question, but if someone can provide a clue for me that would be great. -- Amer Neely Home of Spam Catcher W: www.softouch.on.ca E: [EMAIL PROTECTED] Perl | MySQL | CGI programming for all data entry forms. We make web sites work! -- 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 5 / phpMyAdmin - SOLVED
Thanks to Ing. Edwin Cruz and George Law for pointing me in the right direction, as previous messages in this thread indicate. phpMyAdmin now working great with MySQL 5.0. Have a loot on this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html try a search for old_password -- Amer Neely Home of Spam Catcher W: www.softouch.on.ca E: [EMAIL PROTECTED] Perl | MySQL | CGI programming for all data entry forms. We make web sites work! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and phpMyAdmin
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
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 http://dev.mysql.com/doc/mysql/en/old-client.html 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
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
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
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]