Support Center > Knowledgebase > DirectAdmin > MySQL / MariaDB > Forcing mysql_upgrade after a version change
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
Also Read