Re: Help understanding the whole password issue

2006-11-28 Thread Eric Bergen
Mathieu, The old_passwords option only changes how mysqld generates new passwords. If old_passwords=0 when you create a new user mysql will generate a long password that will only accept clients using the newer protocol (and client lib). When old_passwords=1 mysql will generate the older shorter

Re: Help understanding the whole password issue

2006-11-28 Thread Mathieu Bruneau
I may not be totally right but : 1) Well it all depends of which client library they are using if they are using the old library yes 2) Well if that client use the old libraby yes ... (btw you can check the password field in the mysql.user table to view the difference => they have a different for

Help understanding the whole password issue

2006-11-28 Thread Joey
I need some clarification on the old password issue as I am having problems logging in. Here is what I am running into now. Original Server config: my.cnf is NOT using the old_passwords=1 under MySQL-server-4.1.14-0 I am able to login via phpmyadmin without problem, remotely with mysqladmin a