MySQL Installation and Configuration (2019)
1h 41mIntermediate2019-07-15
Authors
Bill Weinman
Tech Advocate, Entrepreneur, Programming Expert
Course details
Whether you're a developer, a database analyst, or just someone looking to manage data for their small business, having the ability to install and configure MySQL is a professional asset. In this course, join instructor Bill Weinman as he steps through how to install and configure MySQL on various platforms. Bill shows how to install MySQL on a Mac, as well as machines running Windows and Ubuntu Linux. He demonstrates how to create user accounts, assign database access privileges, and manage passwords. Plus, he goes over the different storage engine options in MySQL, including InnoDB.
Learning objectives
Installing MySQL on macOS, Windows, and Linux
Installing MySQL Workbench
Importing SQL data into MySQL
Creating user accounts
Managing roles
Implementing storage engines
Creating a new database
Learning objectives
Installing MySQL on macOS, Windows, and Linux
Installing MySQL Workbench
Importing SQL data into MySQL
Creating user accounts
Managing roles
Implementing storage engines
Creating a new database
Skills covered
MySQLDatabase DevelopmentDatabase ManagementOpen SourceSoftware DevelopmentOne-Off
Concepts
Introduction
- Demystifying the server
- A brief history of MySQL
Installation
- Installing MySQL on a Mac
- Installing MySQL Workbench on a Mac
- Installing MySQL on Windows
- Running MySQL Workbench on Windows
- Installing MySQL on Ubuntu Linux
- Install MySQL Workbench on Ubuntu
- Installing some example databases
Accounts and Privileges
- Creating user accounts
- Hostnames and wildcards
- Database access privileges
- Access roles
- Password expiration
Storage Engines
- MySQL storage engines overview
- The CREATE TABLE statement
- InnoDB
- MyISAM
- MEMORY
Conclusion
- Thank you