Look for OLD_PASSWORD in the manual. Basically create a new user and then change the password with the OLD_PASSWORD function and then pre-4.1 clients can connect without any problems. We use it all of the time.
Why is that not documented, again?
http://dev.mysql.com/doc/mysql/de/Function_Index.html http://dev.mysql.com/doc/mysql/search.php?q=OLD_PASSWORD&lang=de&charset=iso-8859-1
(The search only finds a lot of "password" garbage. Could someone please fix it?)
-- Yves Goergen <[EMAIL PROTECTED]>
BlackBoard Internet Newsboard System --> blackboard.unclassified.de Free (GPL), easy to use and install, secure, innovative! (PHP+MySQL)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
