Sys config error in 8.0

from the Artful MySQL Tips List


In 8.0, upgrading from an earlier version can elicit an error like this ...
Cannot open datafile for read-only: './sys/sys_config.ibd'
The manual covers such errors at https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html. A Ubuntu 20.04 user found this sequence worked ...
sudo -u mysql mysqld --upgrade=MINIMAL --skip-grant-tables --skip-networking &
mysql -u root
  DROP DATABASE sys;
  EXIT;
sudo killall mysqld
sudo service mysql start

Last updated 31 Oct 2020


Return to the Artful MySQL Tips page