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 2024 |