In this video, get a brief history of MySQL. Learn how client and server architecture affects usage and explore the variations from standard SQL. Additionally, learn about MariaDB and other forks.
- [Instructor] MySQL is an open source, general purpose, relational database management system, originally written by Michael Monty Widenius and David Axmark. Monty Widenius served as the primary developer for most of the code's history. Monty has said that the correct pronunciation is my ess-que-ell, but that he doesn't mind if people choose to pronounce it differently. MySQL is written in C and C++, and runs on a variety of platforms including Unix, Linux, and their derivatives, Mac OS, Windows and many others. Most cloud computing platforms provide MySQL instances, including Amazon Web Services, Rackspace, and even Microsoft Azure. MySQL began as an open source alternative to mSQL, a small database system that was popular for personal applications in the mid 90s. mSQL was never offered under an open source license, and its legality as a database for websites was somewhat ambiguous. MySQL was fully API-compatible with mSQL, making it a viable drop-in replacement for many applications. Since its first public release in May of 1995, MySQL has been offered under the GNU General Public License. Upon release of the first version of MySQL, it was owned and administered by MySQL AB, founded by the developers. Their business model was to sell proprietary licenses with support contracts, while keeping the code fully GPL compliant. Development continued throughout the late 90s and early 2000s, and MySQL evolved into a full featured, enterprise capable, relational database management system. By 2008, MySQL had become the runaway favorite database management system for websites, small and medium sized businesses, and rumors had MySQL AB filing for an IPO, but instead, they were acquired by Sun Microsystems. Sun kept the original team and allowed them to continue running the MySQL part of the business. As the mini computer business slowed down, Sun Microsystems ran into financial problems, and in January 2010, they were acquired by Oracle Corporation. Monty Widenius immediately took his development team and founded Maria Corporation AB and created a fork of the open source MySQL as MariaDB, named after his second daughter. Many people, including myself, had feared MySQL would not survive, but it has thrived under Oracle stewardship. Oracle has a reputation for being hostile toward open source products, but they have continued MySQL's successful business model and have applied their extensive database expertise to the project and made it into a significant force in the database world. Today, MySQL is as powerful as any major database system, supporting full acid compliant transactions, foreign key constraints, database partitioning clusters, and many more advanced database features. As of this recording, the current supported version of MySQL is version 8.0. 5.7 and 5.6 are still supported, with support for 5.7 Sun setting in October 2023. This course uses MySQL 8.0. The official graphical interface for MySQL is MySQL workbench, which is included in the standard MySQL distribution. MySQL is an essential part of many development and application environments. In this course, I will show you how to install MySQL on a Mac, on Windows, and on Ubuntu Linux.
- 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