Is there a way to tell mysql 4 to defaul to the old style passwords instead of having to run this every time we add a user?
SET PASSWORD FOR <mailto:'user'@'localhost'> 'user'@'localhost' = OLD_PASSWORD('passowordo'); Applications we develop in php, and phpMyadmin don't seem to work with the new style password. Thanks!