Add to Favourites Add to Favourites    Print this Article Print this Article

Forcing mysql_upgrade after a version change

When MySQL/MariaDB is updated in CustomBuild, it should automatically call the mysql_upgrade command.
Sometimes, you might be working with things manually, or just want try force another upgrade call.
To do this, run:

/usr/bin/mysql_upgrade --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --force

where the --force option is optional, but sometimes needed if the script thinks it's already up to date, but you're not convinced it is.

Note, on Debian/FreeBSD systems, the binary is at:

/usr/local/mysql/bin/mysql_upgrade --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --force

Was this answer helpful?

Also Read