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 database!
I’m sure you’re familiar with what a database is, if not, here’s the definition.
A database is a structured set of data held in a computer, especially one that is accessible in various ways.
In the MySQL – you can build multiple ‘folders’ in your database, called schemas.
Schema VS Database
A database is your primary container; it contains the data and log files, and all the schemas within it.
You always back up a database; it is a discrete unit on its own.
Schemas are like folders within a database and are mainly used to group logical objects together, which leads to ease of setting permissions by the schema.
Creating a Schema in MySQL Mac OS
Let’s talk about the point and click methods first.
When you have your workbench open – you’ll notice a place on the bottom left labeled “SCHEMAS,” and that’s where we want to click right to build a new Test Database!
Creating your first schema on your Mac OS MySQL.
Setting up your MySQL Schema on your Mac
Let’s start setting up your MySQL Schema.
Name your MySQL schema “Test_Schema1.”
After you right click to create your schema – rename your MySQL schema.
Use UTF-8 for your collation.
What is UTF-8 Collation?
From Wikipedia, the free encyclopedia
UTF-8 is a variable width character encoding capable of encoding all 1,112,064 valid code points in Unicode using one to four 8-bit bytes.
The encoding is defined by the Unicode standard and was initially designed by Ken Thompson and Rob Pike.
The name is derived from Unicode (or Universal Coded Character Set) Transformation Format – 8-bit.
We will use UTF-8 for this schema.
MySQL refers to UTF8 as a common choice. For our needs – let’s use the UTF8 default.
Click apply – which is on the bottom right of the screen.
Left click to apply.
Wrapping up your schema build in Mac OS MySQL Workbench
Let’s wrap up your schema creation in MySQL.
If you’ve followed along you will see this window.
MySQL generates SQL, shows it to you, and maybe that’s easier for you in the future?
This leads us to our next topic.
Using SQL – instead of the GUI!
Using SQL to generate a Schema in your Mac OS on MySQL Workbench
Using SQL is an alternative to the clicks we just gained your first schema. Woot!
Most GUI steps on MySQL will uncover SQL that you’ve generated VIA using a built-in wizard.
The native features in MySQL offer a glimpse into creating your first schema.
CREATE SCHEMA `Test_Schema1` DEFAULT CHARACTER SET utf8 ;
You can copy and paste this code into a query on MySQL.
If you have MySQL Workbench open, you have a query open!
Paste your code and build Test_Schema2.
Change your Schema1 to Schema2. Click the lightning bolt to execute the query.
Now you should have two SCHEMAS – be sure to click the refresh button, and both will be present.
It will look like this screenshot below.
Click the tiny refresh button.
Get used to clicking the refresh button on MySQL Workbench and all other database GUI interfaces.
You’re making changes to something living and breathing on your computer, and right now – you have a database on your computer. Congratulations!
Again, the refresh is a normal process, don’t worry if you don’t see your work – especially if you’ve not refreshed your GUI interface, also known as your MySQL Workbench!
Did you expect it would be this easy to create a Schema in your MySQL Workbench 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 to reset mysql root password on your mac tech tutorial!
1. Stop the mysqld server. Typically this can be done by from ‘System Prefrences’ > MySQL > ‘Stop MySQL Server’
2. Start the server in safe mode with privilege bypass
From a terminal:
sudo /usr/local/mysql/bin/mysqld_safe –skip-grant-tables
3. In a new terminal window:
sudo /usr/local/mysql/bin/mysql -u root
UPDATE mysql.user SET Password=PASSWORD(‘NewPassword’) WHERE User=’root’;
4. Stop the mysql server again and restart it in normal mode.
We found these steps @ https://www.variphy.com/kb/mac-os-x-reset-mysql-root-password
Resetting MySQL Root Password on Mac OS – To build SQL on CSV environments.
If you’re a heavy Tableau desktop user – it’s smart to have MySQL installed on your Mac OS.
If you install MySQL on your Mac – you can utilize MySQL Workbench and it will increase your solution capability in a CSV environment.
- Install MySQL on Mac
- Download MySQL Workbench
- Log in to your MySQL instance with Workbench
- Input your root password.
Why do we need MySQL updated right now?
Install MySQL Mac the easy way using our tech tutorial – walkthrough below.
Thanks stopping by to read about installing MySQL on your Mac!
We mostly type about Tableau Consulting and other fun tech tutorials.
Install My SQL Mac – The Guide on How To Install Mysql on Mac
Tutorial 1 – Install MySQL Mac, MacBook Pro, MacBook Air!
Installing MySQL on a Mac – Pro, Air, or whatever.
Let’s take it from the top! Install MySQL Mac – Tutorial one, is the first step to becoming a data analyst.
MySQL is going to keep you from making a massive mountain of Excel that no one wants ever to touch. Ever.
Are you getting tired of your spreadsheets!
Utilizing Mac to be your at home database might just work for you.
Why Install MySQL Mac?
It’s free, it’s easy, and it scales.
Every Excel expert would benefit from learning how to do their work in a database.
Install MySQL Mac: Installing MySQL on Mac in <5mins
MySQL .pkg contains our MySQL installer now owned by Oracle.
What a beauty! 29 characters with a suffix of .pkg will be all you need to install MySQL Mac.
- Double click the installer.
- Install MySQL – community installer opens.
- Click continue.
- GNU General Public Licenses – essentially you’re free to change the product however you want, use it however you want, and not get hit with a price down the road. You create your limitations and have the flexibility to solve them as you see fit.
- Click Continue and Agree to Install MySQL on your Mac
- Change installation directory, if you have multiple drives, this will apply to you.
- Click Install. If you have a password protection on your Mac installations, you will need to provide that password.
- Save root password by copy and pasting to your notepad.
Install MySQL Mac – When you’re installing MySQL, you’re given a root password, and also CMD+A and CMD+C will copy this password for you to paste.
You thought there would be more?
MySQL, founded in 1995, and now it’s installed on your MacBook Pro! Good luck!
Installing databases is a mandatory skill belt notch – Installing MySQL on Mac is Easy!
Although it’s a necessary skill belt notch for nearly every Fortune 500+ company, I find that most people have no Data experience and rather are very good at using the software.
Data scientists, data analysts, Directors of Analytics, CIO, etc. I’ve seen hundreds of them in person, and they had never installed a database before.
Even CIO’s for 100million+ companies have no idea what a database does or how to use it. They have an ear full of sales and often buy wrong solutions that require fixing in the future.
They had a title with the word data in it!
Install MySQL Mac – Dependency on data products generates broken environments
After working in classic business enterprises and also fast booming companies.
I’ve noticed fundamentals missing from most ‘data experts’ skill belts and yet they are the expert at the entire organization.
Shadow IT internal and external make an absolute mess of Data environments and keep us very busy with fixing their mistakes.
Everyone seems to know enough to say the verbiage.
Regrettably, when the rubber meets the road, they are plugging their SQL into Notepad++ and spending weeks on easy SQL because the fundamentals were never acquired.
Installing a database on a computer takes <1minute.
Installing a database on your computer takes <1minute, yet nearly every expert I’ve come across has never installed a database and runs away from SQL discussions.
Why is it mandatory to know how to install a database?
Installing a database is the bread and butter of any reporting tool.
If you do not have data experience and you’re plugging data in a tool like Tableau Desktop – be sure to understand the impacts of your usage.
Being able to install MySQL on Mac might be your next step!
Installing a database like MySQL on your computer gives you an opportunity to see what it takes to manage your database, and also see the impacts of your usage when connected to the data live!
How do you query your local database? Do you use another database?
Start MySQL on Mac OSX or build a farm of spreadsheets? We will be walking you through building your database on your personal machine. Start MySQL on Mac OSX and Get Collecting! Ever considered collecting data to process MySQL? When ramping up you need to start the MySQL instance on your Mac OSX. This is a quick guide!
By the end of this blog, you will understand how to get your MySQL Server started on your Mac OS.
Now that you have MySQL on your Mac, what’s next? Start MySQL on Mac OSX!
- The first step is installing MySQL on your mac.
- The next step is starting MySQL.
- Open your settings and find your MySQL icon.
Mac OS MySQL button in Settings.
You can start and stop your MySQL database manually here.
More MySQL Server Startup Details
We want to kick off a component of the service, it’s called launchd.
To enable the launchd service – we want to jump into the easy mode first!
If you’re coming from SSMS and looking to have a similar feel with the Mac OSX MySQL install. That’s our objective too.
Download MySQL Workbench!
Then follow along in our next tutorial on How to Create a Schema in your MySQL Workbench on Mac OS.
If you’re not perfect, you may forget your root password. We cover how to reset your root password here.