MySQL Installation and Configuration

Focused View

Bill Weinman

1:20:20

9 View

01 - Introduction

01 - Demystifying the server.mp4

00:53

02 - A brief history of MySQL.mp4

03:49

02 - 1. Installation

01 - Installing MySQL on a Mac.mp4

09:48

02 - Installing MySQL Workbench on a Mac.mp4

07:17

03 - Installing MySQL on Windows.mp4

05:52

04 - Running MySQL Workbench on Windows.mp4

06:30

05 - Installing the example databases.mp4

09:21

03 - 2. Accounts and Privileges

01 - Creating user accounts.mp4

06:03

02 - Hostnames and wildcards.mp4

02:04

03 - Database access privileges.mp4

07:11

04 - Access roles.mp4

07:41

05 - Password expiration.mp4

03:45

04 - 3. Storage Engines

01 - MySQL storage engines overview.mp4

02:44

02 - The CREATE TABLE statement.mp4

02:24

03 - InnoDB.mp4

01:47

04 - MyISAM.mp4

01:05

05 - Memory.mp4

01:25

05 - Conclusion

01 - Thank you.mp4

00:41

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Database Programming

Bill Weinman

Instructor's Courses

I cleverly manipulate unsuspecting electrons to teach you about technology and other cool things. I'm primarily an educator, I teach online courses and write books on computer languages and programming. I built my first computer in 1972, using an Intel 4004 4-bit microprocessor and parts from a local Radio Shack. Over a 45+ year career, I've consulted for major corporations, including NASA, IBM, Bank of America, the US Navy, and KWHY-TV, where I designed the world’s first broadcast lower-third stock ticker. I've written popular books and courseware on C, C++, Perl, Python, SQL, and more. My courses have consistently been ranked in the top-10 on lynda.com and Linkedin Learning’s training sites. // Students: Please do not direct message me on Linkedin for technical support with my lynda.com/Linkedin Learning courses. I rarely see my Linkedin messages. You may tag me in a post or use the course Q&A system. // Recruiters: Please do not contact me for captive positions. I occasionally do some consulting, but mostly I am booked at least a year in advance. If you need to contact me directly, please see my web site https://bw.org/contact

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.