| Version Number | 1.234 |
| Finished | Yes |
| Type | bugfix |
If you are using mysql 4.1.x, phpMyAdmin isn't able to work with the new password format for mysql.
FIX:
cd /usr/local/directadmin/customapache ./build clean ./build update ./build php n
NOTE: If you are using apache 2, use ”./build php_ap2 n” instead.
What it does:
uses –with-mysql=/usr instead of just ”–with-mysql” in the configure.php file, assuming you have /usr/include/mysql/mysql.h. For FreeBSD, it would be ”–with-mysql=/usr/local/mysql”. The customapache script is updated with this change, so do a ”./build clean; ./build update; ./build php n” and it should use the actual installed mysql client libraries you have on your system instead of using the client mysql libraries that php includes (3.x).
If you are upgrading to 4.1, then you'll also have to update the grant tables to have a longer password field. Type:
mysql_fix_privilege_tables --user=da_admin --password=`cat /usr/local/directadmin/conf/mysql.conf | grep passwd |cut -d= -f2` http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html
Once updated, you'll have to resave the passwords so that they are stored in their full length.
Another possible fix:
[mysqld] old_passwords
To the /etc/my.cnf. Reset your mysql passwords through DA.