SQL - Installation (MySQL, SQL Server, SQLite)
Overview
Choose one (or more) engines to install locally. We’ll verify installation and run a quick smoke test.
Install options
MySQL
- macOS: Use the MySQL DMG installer or Homebrew:
brew install mysql - Start:
mysql.server start(brew) or via System Preferences (DMG) - Client:
mysql -u root -p
SQL Server
- macOS: Use Docker:
docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD={{STRONG_PASSWORD}}' -p 1433:1433 --name sqlserver -d mcr.microsoft.com/mssql/server:2022-latest - Client: Azure Data Studio or
sqlcmd
SQLite
- macOS:
brew install sqlite - Client:
sqlite3 my.db
Verify with a quick query
SELECT VERSION();
SELECT @@VERSION;
SELECT sqlite_version();
Tip for beginners: Use a GUI client (MySQL Workbench, Azure Data Studio, or DB Browser for SQLite) alongside the command line; teachers can demo both.