How to install sample MySQL database on Mac?
A simple guide to download and install MySQL sample database on Mac
Where to download the MySQL sample database?
You can go to MySQL Other Documentation to get some example MySQL databases. Choose a sample db and download it.
Install sample MySQL database on Mac
Unzip the sample db file.
Type the following command to connect to MySQL server
/usr/local/mysql/bin/mysql -u root -p
Then it will prompt for your password, or you can input password right away:
/usr/local/mysql/bin/mysql -u root -p[password]
Then find the path to the sql file you just download and unzip. It might be something like this:
/Users/Your_username/Downloads/sample.sql
Then execute the .sql file
mysql> SOURCE /Users/Your_username/Downloads/sample.sql;
Now you’re good to go. Use TablePlus to connect to your localhost and play with your sample MySQL database
New to TablePlus? It’s a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.
Not on Mac? Download TablePlus for Windows.
On Linux? Download TablePlus for Linux
Need a quick edit on the go? Download TablePlus for iOS.
