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 passwords that will accept clients using the old protocol (and client lib)
It's possible to have some clients use the old protocol and some using the new protocol by changing their passwords accordingly. This is what the old_password function is for in both mysql and phpmyadmin. -Eric On 11/28/06, Mathieu Bruneau <[EMAIL PROTECTED]> wrote:
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 format, newer one are much longer and start with an * so you know which user uses the new and the old scheme) 3) No '%' means everything except localhost... That's a special case in mysql :) Regards, -- Mathieu Bruneau aka ROunofF === GPG keys available @ http://rounoff.darktech.org Joey a écrit : > 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 > and of course applications. > perl-DBD-MySQL-2.9003-5 > MySQL-devel-4.1.14-0 > MySQL-server-4.1.14-0 > MySQL-client-4.1.14-0 > php-mysql-4.3.11-2.8.4.legacy > mod_auth_mysql-20030510-5 > MySQL-shared-compat-4.1.13-0 > MySQL-embedded-4.1.14-0 > MySQL-bench-4.1.14-0 > > > > New Server config: > tried old_passwords=1 both on & off under mysql-4.1.20-1.RHEL4.1 > libdbi-dbd-mysql-0.6.5-10.RHEL4.1 > mysql-4.1.20-1.RHEL4.1 > mod_auth_mysql-2.6.1-2.2 > php-mysql-4.3.9-3.22 > mysql-bench-4.1.20-1.RHEL4.1 > mysql-server-4.1.20-1.RHEL4.1 > mysqlclient10-3.23.58-4.RHEL4.1 > perl-DBD-MySQL-2.9004-3.1 > MySQL-python-1.0.0-1.RHEL4.1 > mysql-devel-4.1.20-1.RHEL4.1 > > New server tried running with both the old_passwords=1 and not really > getting consistant results. > yes I restart mysqld after changes etc. Part of the problem may also be > related to the host field in which some times I use the % so that I can > connect via the gui tools. > > So are my questions: > > 1. if I want to use the older apps, and phpmyadmin etc do I need to run > old_passwords=1? > > 2. If I start mysqld with the old_passwords=1 set, when I use phpmyadmin to > edit someone's password do I need to use the password drop down or the > old_password drop down? > > 3. For remote access if I setup % in the host as I have done in the past > that should allow me to login both remotely & to localhost right? > ( again this works perfectly on my older box) > > > Hope this makes sense. > > Thanks, > > Joey > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]