Top Web Hosts >> Forums >> Database Programming and Administration

Write

· Name ¡¤ Psssword ¡¤ E-mail ¡¤ Homepage · Option html  Reply-mail  · Subject · Content > > > Q. After MySQL upgrade from 3.5.x to 4.1.x, the mysql passwords do not work anymore. Is there a quick fix for this? > > A. The MySQL 4.1.x (or above) may have to respond to auth requests from "old" clients, such as a prebuilt PHP binary or any application that may use built-in mysql libs. To make 4.1.x (or above version) work with the applications used in older versions (i.e. 3.5.x), you'll have to make old-password compatible with the new with command-line option. > > Option 1. > For MySQL 4.1 or later, the my.cnf file may be used to specify configuration options. In addition to specifying the basedir and datadir values, you may also set the old-passwords option, which will instruct MySQL to use PHP-compatible passwords: > [mysqld] > basedir = ... > datadir = ... > old-passwords=1 > max-connections=150 > default-character-set=latin1 > default-collation=latin1_bin > > > Option 2. > Start mysqd with --old-passwords option > # mysqld --old-passwords > > To see wheter MySQL is using old or new passwords, perform the following on the MySQL client: > > mysql> SELECT Host, User, Password FROM mysql.user > -> WHERE LENGTH(Password) > 16; > > If it returns the rows, it is using the new passwords. > · Link #1 · Link #2 · File + - ¡¤ be1e8b695d   * Enter the red characters on the left.