MySQL Installation and Configuration

MySQL Installation and Configuration

1h 20mIntermediate2024-03-07

Authors

Bill Weinman

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

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 the 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
40,000 Toman