note 48092 added to ref.mysql

From: Date: Sat, 11 Dec 2004 10:32:19 +0000
Subject: note 48092 added to ref.mysql
Groups: php.notes 
Request: Send a blank email to php-notes+get-81678@lists.php.net to get a copy of this message
Re Pat's note: You can add the --old-passwords option in the [mysqld] section of your MySQL my.cnf or my.ini configuration file. This option will force the MySQL server to use the old-style password hashing for all connections. This is not really recommended, as it's less secure, but will allow you to use existing accounts without resetting the passwords. Of course, as already mentioned, you can use the MySQL OLD_PASSWORD() function instead to handle this issue on an account-by-account basis. The optimal solution when migrating to MySQL 4.1+ from a previous version is to upgrade to PHP 5 (if you're not using it already) and rewrite any code accessing MySQL using the mysqli extension, which is more secure and provides a much better API. For more information, see the MySQL Manual: http://dev.mysql.com/doc/mysql/en/Application_password_use.html ---- Manual Page -- http://www.php.net/manual/en/ref.mysql.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+48092 Delete -- http://master.php.net/manage/user-notes.php?action=delete+48092&report=yes Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+48092&report=yes&reason=bad+code Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+48092&report=yes&reason=spam Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+48092&report=yes&reason=useless+example Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+48092&report=yes&reason=contains+commercial+links Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+48092&report=yes&reason=useless+note Reject -- http://master.php.net/manage/user-notes.php?action=reject+48092&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#81678) next »