Installing MySQL 5.1 under DA

paulvr

New member
Joined
Mar 18, 2009
Messages
2
After installing MySQL 5.1 under DA the initial MySQL tables were corrupted. I suspect DA to do something with those tables or the my.ini settings file that does not respect the 5.1 format, which differs from 5.0. Running the mysql_upgrade tool (available on the MySQL bin directrory), solved the problem (even on a fresh installation).
Regards, Paul.
 

DirectAdmin Support

Administrator
Staff member
Joined
Feb 27, 2003
Messages
8,965
Hello,

The custombuild script already does call mysql_upgrade, eg:
Code:
                if [ -e /usr/bin/mysql_upgrade ]; then
                        /usr/bin/mysql_upgrade --user=${MYSQLUSER} --password=${MYSQLPASSWORD}
                elif [ -e /usr/bin/mysql_fix_privilege_tables ]; then
                        /usr/bin/mysql_fix_privilege_tables --user=${MYSQLUSER} --password=${MYSQLPASSWORD}
                fi
if mysql was just updated manually, then never mind ;) Using the custombuild script is recommended for such operations.
Let me know if you're referring to something else, or some other method.

Thanks!
John
 
Top