MySQL primer – Creating a database

MySQL primer – Creating a database cover image
  1. Home
  2. MySQL
  3. MySQL primer – Creating a database

On this page I will show you how to make a MySQL database on your computer. Additionally, I will also tell you how to provide permissions for the newly created database.

The commands for creating a database in Windows and Linux/Unix are the same. However, the preliminary commands in Linux are slightly more complex. Since this tutorial is meant for the complete newbie, I’ll discuss the Windows and Linux/Unix systems separately.

Sponsored Links

BignetWe’ll create a database called employees that contains details of employees of our company Bignet. The details we plan to store would be names, salaries, age, addresses, emails, birth dates, hobbies, phone numbers etc.

Creating MySQL database on Windows system

Creating MySQL database on Linux system

MySQL