note 48092 added to ref.mysql
| From: | jonatmysqldotcom at osu1 dot php dot net | 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