you can still do a dump and restore, it works nicely. I think the problem is that he users table changed. I have a 4.1 server running, i just do a dump and restore from the old server to the new one. and added the --old-password option.
Hope this helps! On Thu, 2004-01-08 at 16:14, Victor Medina wrote: > It did change, but you can still use the old protocol by adding > --old-passwords option to the mysqld or adding old-passwords option to > the [mysqld] group in my.cnf, using this, old clients will be able to > connect to 4.1 series servers without probs :) > > By the way, i am not quite sure, but you should remove the down legal > note, i think the mysql list is public and free to every one to use and > quote, so while posting here it is better to remove the note, maybe > someone at mysql.com could confirm this? > > Best Regards > On Thu, 2004-01-08 at 15:45, [EMAIL PROTECTED] wrote: > > > I have a workstation that I set up as a 4.0.16 server to prove to myself > > that I could use MySQL for an application we are developing. Now, for beta > > testing, I set up a new 4.1.1 server on a real server box. I did not > > upgrade the workstation with the 4.0.16 server. In setting up the new > > server, I ran the mysql_fix_privilege_tables script and restarted the > > server with the --old-passwords option. I then logged in locally as root > > and created a new user account for me from my OTHER workstation with the > > 4.0 client. Unfortunately, as long as my account on the new server has a > > password, I can't log in. I get the old standby, "Client does not support > > authentication protocol requested by server; consider upgrading MySQL > > client." I went back to the documentation and it slowly dawned on me that > > it was speaking strictly of an UPGRADE to an existing installation when it > > talked about old passwords and the like. Consequently, I am beginning to > > suspect that I cannot install a new 4.1.1 server and still use 4.0 > > clients. Is this correct or am I missing something (wish I could say that > > was unlikely ;->)? > > > > Thanks > > > > > > Randolph "Randy" L. Chrismon > > [EMAIL PROTECTED] > > > > > > > > > > Confidentiality Note: This message and any accompanying attachments > > contain information from the law firm Fragomen, Del Rey, Bernsen & Loewy, > > P.C. which is confidential or privileged. The information is intended to > > be for the use of the individual or entity named above. If you are not the > > intended recipient, be aware that any disclosure, copying, distribution or > > use of the contents of this information is prohibited. If you have > > received this e-mail in error, please notify our offices immediately, by > > telephone at 212-688-8555, or by e-mail at [EMAIL PROTECTED] -- |...........................................................| |____ _____ ____ _ |Victor Medina M | |\ \ \| ____| _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_____|_| /_/ \_\|ext. 325 | | |geek by nature - linux by choice | |...........................................................|