How to Install MySQL on Mac | Learn MySQL CLI | Fix Data Import Errors Unhandled exception 'ascii'
In this video, I guide you step-by-step through installing MySQL on Mac using Homebrew and MySQL Workbench. Whether you're a beginner or experienced user, this tutorial will walk you through:
🎯 Get Latest SQL Guided Project (1M sales records)
🎯https://topmate.io/zero_analyst/1237072
🎯 Get Latest
End to End Advanced SQL Project (Amazon)+ 70 Business Problems
• Advanced SQL Data Analysis Resume Pro...
🐍 All Python Projects:
Python ETL - Data Cleaning Project
• Data Analytics Python Resume Project ...
💡All Commands Used:
1. 🍺 Homebrew Setup Command:
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Hom...)"
2. Install MySQL & Workbench:
brew install mysql sqlworkbench
3. Start MySQL Server (First Time):
brew services start mysql
4. Check if local_infile is Enabled:
SHOW VARIABLES LIKE 'local_infile';
5. Enable local_infile to Import Data:
SET GLOBAL local_infile = 1;
6. Launch MySQL from Terminal with Local File Import Enabled:
mysql --local-infile -u root -p
7. Data Import Command:
LOAD DATA LOCAL INFILE 'your_csv_file_path.csv'
INTO TABLE your_table_name
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
With this guide, you’ll be able to set up MySQL, use it efficiently via CLI and Workbench, and troubleshoot common import errors. Perfect for data analysts, developers, or anyone managing databases on Mac.
Timestamps:
0:00 - 0:37 - Introduction
1:03 - 3:00 Installing MySQL with Homebrew
3:15 - 8:30 Installing MySQL Workbench
10:45 - 12:45 Create Table Using CLI
15:00 -21:00 Fixing Import Errors in MySQL Workbench
28:30 - 39:00 Common Error While Importing Data Into MySQL - Unhandled exception: 'ascii' codec can't decode byte Oxef in position 0: ordinal not in range (128)
🎯 Get Latest SQL Guided Project (1M sales records)
🎯https://topmate.io/zero_analyst/1237072
🎯 Get Latest
End to End Advanced SQL Project (Amazon)+ 70 Business Problems
• Advanced SQL Data Analysis Resume Pro...
🐍 All Python Projects:
Python ETL - Data Cleaning Project
• Data Analytics Python Resume Project ...
🛢All SQL Projects
Project 1:
🎯 Retail Sales Analysis - • SQL Data Analysis Portfolio Project #...
Project 2:
🎯 Library Management System - • SQL Data Analysis Portfolio Project #...
Project 3: (Advanced SQL)
🎯 Zomato Food Company Data Analysis
• Advanced SQL Data Analysis Project | ...
Project 4:
🎯 Netflix Movies Data Analysis
• Advanced SQL Project | Netflix Data A...
Project 5:
🎯 Amazon Sales Analysis (Advanced SQL)
• Advanced SQL Data Analysis Resume Pro...
Project 6:
🎯 Spotify Data Analysis
• Advanced SQL Project | Spotify Data A...
Project 7: (Advanced SQL)
🎯 Apple Retail Sales Analysis - 1M Sales Records
• Data Analytics Resume Project | Apple...
Project 8: (Real Business Problems)
🎯 Monday Coffee Extensions Analysis
• Data Analyst SQL Project Beginners So...
Book 1:1 Mentorship - https://topmate.io/zero_analyst
SQL Live Workshop - https://zeroanalyst.com/course/
Excel Live Workshop - https://zeroanalyst.com/course/
Setting up MySQL via Homebrew
Using MySQL CLI (Command Line Interface) for database management
Importing data into MySQL server using CLI commands
Installing and working with MySQL Workbench for database operations
Fixing common data import errors in MySQL Workbench
#MySQL #MySQLTutorial #MySQLWorkbench #DatabaseManagement #Homebrew #SQL #SQLTutorial #MacSetup #DatabaseErrorFix #ZeroAnalyst