Install MySQL

MySQL installed directly on your machine, running in the background and secured.

Install MySQL
Terminal
```
brew install mysql
```
Start it now and on every login
Terminal
```
brew services start mysql
```
Set a root password and remove test data
Terminal
```
mysql_secure_installation
```
Answer the questions. Yes to everything is a good default.

Check it worked

Log in
Terminal
```
mysql -u root -p -e "SELECT VERSION();"
```

Undo it

Stop and uninstall

Terminal

brew services stop mysql && brew uninstall mysql

Install MySQLNeeds sudo
Terminal · Ubuntu / Debian
```
sudo apt install -y mysql-server
```
Start it now and on every bootNeeds sudo
Terminal · Ubuntu / Debian
```
sudo systemctl enable --now mysql
```
Remove test data and lock things downNeeds sudo
Terminal · Ubuntu / Debian
```
sudo mysql_secure_installation
```
On Ubuntu, root logs in through sudo rather than a password.

Check it worked

Log in
Terminal · Ubuntu / Debian
```
sudo mysql -e "SELECT VERSION();"
```

Undo it

Uninstall MySQLNeeds sudo
Terminal · Ubuntu / Debian
```
sudo apt remove -y mysql-server
```

Install MySQL
PowerShell
```
winget install Oracle.MySQL
```
The setup window asks you to set a root password. Keep it somewhere safe.

Check it worked

Log in
PowerShell
```
mysql -u root -p -e "SELECT VERSION();"
```
If mysql isn't found, open "MySQL Command Line Client" from the Start menu instead.

Undo it

Uninstall MySQL
PowerShell
```
winget uninstall Oracle.MySQL
```