MySQL Installation and Configuration
1h 20mIntermediate2024-03-07
Authors
Bill Weinman
Tech Advocate, Entrepreneur, Programming Expert
Course details
In this beginner-friendly course, Bill Weinman—tech advocate, entrepreneur, and programming expert—guides you through the full process of installing and configuring MySQL. After reviewing a brief history of MySQL, dive into installing MySQL and MySQL Workbench on Mac and Windows, as well as installing the example databases. Learn how to create user accounts and use hostnames and wildcards. Get a useful overview of access permissions and access roles and find out how MySQL supports password expiration, reuse restrictions, and dual passwords. Plus, find out how MySQL storage engines work and explore the InnoDB, MyISAM, and Memory storage engines.
Skills covered
MySQLDatabase AdministrationDatabase DevelopmentDatabase ManagementOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Demystifying the server
- 02 - A brief history of MySQL
1. Installation
- 03 - Installing MySQL on a Mac
- 04 - Installing MySQL Workbench on a Mac
- 05 - Installing MySQL on Windows
- 06 - Running MySQL Workbench on Windows
- 07 - Installing the example databases
2. Accounts and Privileges
- 08 - Creating user accounts
- 09 - Hostnames and wildcards
- 10 - Database access privileges
- 11 - Access roles
- 12 - Password expiration
3. Storage Engines
- 13 - MySQL storage engines overview
- 14 - The CREATE TABLE statement
- 15 - InnoDB
- 16 - MyISAM
- 17 - Memory
Conclusion
- 18 - Thank you