Forcing mysql_upgrade after a version change

Enter Your Query:
Use '%' for wildcards and quotes for "exact phrases"

Top Level » MySQL / MariaDB

Forcing mysql_upgrade after a version changeLast Modified: Nov 22, 2017, 2:38 pm
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

© 2018 JBMC Software, Suite 173  3-11 Bellerose Drive, St Albert, AB  T8N 1P7  Canada.  Mon-Fri 9AM-5PM MST