How to Create a Schema in your MySQL Workbench on Mac OS

Let's create a Schema in your MySQL Workbench on Mac OS. Welcome to a quick and user-friendly guide to generating your first schema in MySQL. By the end of this blog, you will understand how to generate a MySQL schema. A schema is necessary for importing CSV files or JSON files because our end objective is uploading CSVs and performing custom SQL, and pushing that content into Tableau Desktop. Our following blogs will help you with importing a CSV into MySQL on your Mac OS. If you don't currently have MySQL on your Mac OS - follow our other tutorial on how to install MySQL on your Mac. You're creating a schema - not a database! Firstly we are going to want to understand the verbiage used in the product and the difference between database and schemas. After you've downloaded MySQL workbench - we will want to begin bringing in data for Tableau consumption. MySQL has Schemas in the…


A Quick Tutorial - Resetting MySQL Root Password on Mac OS

Resetting MySQL Root Password on Mac OS tutorial. Use case: You're logging into your MySQL Workbench app on your Mac OS and on the first startup. Workbench requires a Root Password. If you've misplaced it, there's a quick process to dig through. Let's start with the easy method - did you save it somewhere? Click the magnifying glass on the top right and search for it, if you built notes for your password. If you took notes of your Root Password - try searching for it first. Here's the text for the temporary password that you can search on your mac. [Note] A temporary password is generated for root@localhost: rt4rvI,%lfr< Maybe you forgot your Mac OS X 'ROOT' password? Or potentially didn't save the Temporary password in your notes? If you did save your root password, it's likely you saved it in a similar fashion to us. How to Reset MySQL root password on your Mac Here's a quick how…