If you’re ready to start writing SQL using MySQL on a Mac, the first step is to install MySQL and MySQL Workbench, then connect the two. This guide walks you through every step, from downloading the software to launching your first MySQL session on macOS.
Whether you’re a data analytics student or building your first database, this tutorial makes setup quick and straightforward.
Step 1: Download and Install MySQL Community Server
To install MySQL on your Mac, follow these steps:
- Go to the MySQL Website
Visit the official MySQL Community Server page. This version is open-source and free to use. - Choose the Right Version
- Version: Pick the latest available version (e.g. 9.1.0).
- Operating System: Select macOS.
- OS Version:
- If you have an Intel processor, choose x86.
- If you have an M1, M2, or M3 chip, choose ARM.
Not sure which chip your Mac uses? Click the Apple icon in the top-left corner > About This Mac.
- Look for Chip to see if it’s Apple Silicon (M1/M2/M3).
- If it says Processor and lists Intel, choose x86.
- Download the DMG Archive
- Look for DMG Archive under the list of download options.
- Click Download on the right-hand side.
- On the next page, click “No thanks, just start my download.”
- Install MySQL
- Open the downloaded .dmg file.
- Double-click the .pkg installer.
- Proceed with the default installation settings.
- When prompted, create a MySQL root password. Write it down ,you’ll need it to connect with MySQL Workbench.
Once installed, MySQL is ready to be used by database management tools like MySQL Workbench.
Step 2: Install MySQL Workbench on Mac
Next, install MySQL Workbench, the GUI used to interact with your MySQL databases.
- Download MySQL Workbench
- Visit the MySQL Workbench download page.
- Select macOS as your operating system.
- Choose the same OS version as you did for MySQL (x86 or ARM).
- Find DMG Archive and click Download.
- Again, click “No thanks, just start my download.”
- Install Workbench
- Open the downloaded .dmg file.
- Drag the MySQL Workbench icon into the Applications folder.
- Open Finder > Applications, then double-click MySQL Workbench.
- On the first launch, you may see a security prompt. Click Open to proceed.
Step 3: Connect MySQL to MySQL Workbench
Once both tools are installed:
- Open MySQL Workbench
- Click “+” to create a new connection
- Use localhost as the hostname and 3306 as the port
- Enter the MySQL root password you created during installation
- Test the connection and save
You now have a working SQL environment on your Mac, ready for queries, database design, and more.
Common Questions
Can I use MySQL without Workbench?
Yes, you can use the command line, but Workbench makes it easier to visualize tables and write queries, especially for beginners.
What if I forget my MySQL root password?
You will need to reset it manually using Terminal and a series of commands. It’s best to store it securely when installing.
Learn More and Advance Your Skills
If you’re looking to go beyond installation and actually start learning SQL and database design, check out the SQL training resources at:
Here, you’ll find self-paced courses and hands-on projects that help you build real skills with SQL, Power BI, and more.
Final Notes
Installing MySQL and MySQL Workbench on macOS is a straightforward process when done step-by-step. Whether you’re preparing for a data job or just experimenting, getting this setup right is your first step into the world of databases.
