Create user mysql after upgrade to 4.1

[Ste_000]

Hi to all, i have upgraded my mysql version to mysql 4.1.15 . Now there is a problem, when i create a mysql user , he can't connect to db because mysql say that haven't permissions !
For this problem i tried some solutions, and now when i create a user, i use this instruction to work connection : mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); > this for each user who i create !!!

but if there is a solution for this problem it's better ! thanks again, bye Ste

 

[lvalics]

/etc/my.cnf

add

old-password

But all password created in new MySQL need to be recreate.

 

[Ste_000]

so i add this line "old-password" to /etc/my.cnf ? thanks again

 

[lvalics]

Yes ...

 

[Ste_000]

excuse me, but i'm not expert ! it isn't this line "old-passwords=1" to add ? and after i must reset also some password for plesk or not?

Thanks

 

[lvalics]

log-bin
server-id=1
old-password

This is how I have ...

 

[Ste_000]

so i edited my my.cnf now and now all works !!! so what say ? thanks very much !!!! bye Ste