MySQL on Kubernetes: How to fix ERROR 1726 (HY000): Storage engine \'MyISAM\' does not support system tables.

Read-only archive. These discussions are from Tracston's earlier technical forum and are kept online because the answers are still useful. New replies are closed. Need help with something like this? Talk to us.

Question 17 Jan 2023

Problem

Pod is failing to load with the following error

How to fix ERROR 1726 (HY000): Storage engine 'MyISAM' does not support system tables. in Mysql 8.0 after CREATE USER

The error encountered after changing version ( downgrading / upgrading ) Even if you deleting the Persistent Volume ( PV )

if you are using hostpath like this

volumeMounts:

- name: mysql-persistent-storage

mountPath: /var/lib/mysql

go to your mounted storage usually you will find a directory inside it with the service name

for example I'm using NFS server mounted in the node /data

the directory is with the old MySQL /data/mysql

remove the entire directory and redeploy the helm / restart the pod

Need this fixed properly?

We do this for a living.

Kubernetes, DevOps and platform engineering, delivered in days — not another weekend lost to a stack trace.

Start a project →