Install Mysql Workbench and get started with Sample Database Table.
After the installation of Mysql database on Mac(refer to this link: How to Install Mysql on Mac Using Homebrew), I felt like playing with mysql database to build a solid foundation for SQL. Of course, we can basically interact with Mysql database in terminal, but it’s not really user-friendly way of working. So, I decided to use Mysql Workbench.
It’s pretty easy to install Mysql Workbench with the following guide provided in mysql official documentation — https://dev.mysql.com/doc/workbench/en/wb-installing-mac.html
Please make sure that your local database server is up and running in the Workbench UI Console.
then, you can connect to the local database server.
In my case, I have imported sample database from Oracle.
Follow this link — https://dev.mysql.com/doc/employee/en/
If you can find rows fetched from Employees table, it is a success.
