Skip to content

Rebuild mysql database

Jaymz Rhime edited this page Jun 11, 2021 · 3 revisions

In case your database becomes corrupted (computer crash or some other disaster), you may need to wipe out all of your mysql files, and start over from zero.

Careful - these commands are destructive! You will lose all of your local databases and tables.

brew services stop mariadb
trash /usr/local/var/mysql
brew reinstall mariadb
brew services start mariadb

sudo mysql_secure_installation

In the mysql installation wizard, type ENTER, ENTER, root, root, ENTER, ENTER, ENTER, ENTER

If it worked, you should be able to connect to your fresh, empty database.

Clone this wiki locally