Stage 1 · Lesson 4 of 8
Installing MySQL locally
Install MySQL Community Server from dev.mysql.com. Choose the current LTS (long-term support) release rather than an . LTS versions change less and match what most hosts run.
Windows and macOS have installers, Linux has official repositories, and Docker is a good alternative. Set a strong password for root, the admin account, and note the port, which is 3306 by default. Check you can connect with the , the command-line client for MySQL.
Then create your own database and a normal user for daily work. Check that tables use InnoDB, the default (the part that stores and locks rows). Also check that the is utf8mb4, so text in any language, and emoji, fits. A local server lets you practise , query plans and restores properly.
Common trapfollowing an old tutorial for MySQL 5.7, whose defaults and syntax differ from the current release in ways that break examples.
A question to check yourself, an AI practice session and 1 cheat sheet entry come with the full roadmap. Unlock
Resources for this stage
Start with· follow one of these
- CourseFreeCS50's Introduction to Databases with SQL
Harvard University · Beginner
Watch Lecture 0 (Querying) for the relational model; it uses SQLite, and the ideas carry straight across
- GuideFreeMySQL Tutorial (official manual)
Oracle · Beginner
The official tutorial chapter: connecting, entering queries and creating your first database and tables