MySQL installation and setup - Mini Project: Build & Apply

MySQL Installation and Setup

📖 Scenario: You are setting up a new MySQL database server on your computer to manage data for a small business. This project will guide you through the basic steps to install MySQL, create a user, and prepare the server for use.

🎯 Goal: By the end of this project, you will have installed MySQL, created a new database user with proper permissions, and verified the installation by connecting to the server.

📋 What You'll Learn

Install MySQL server on your machine

Create a new MySQL user with a password

Grant necessary permissions to the new user

Verify the user can connect to the MySQL server

💡 Why This Matters

🌍 Real World

Setting up MySQL is a common first step for developers and database administrators to manage data for websites, applications, and business systems.

💼 Career

Knowing how to install and configure MySQL is essential for roles like database administrator, backend developer, and data engineer.

1

Install MySQL Server

Download and install MySQL server on your computer using the official installer from the MySQL website or your system's package manager. Ensure the MySQL service is running after installation.

MySQL

# Your code here

Need a hint?

Use the official MySQL installer or your OS package manager to install MySQL server. After installation, check that the MySQL service is active.

2

Create a New MySQL User

Connect to the MySQL server as the root user and run the SQL command to create a new user called newuser with the password password123.

MySQL

# Connect as root and create user
# Your code here

Need a hint?

Use the CREATE USER statement with the exact username and password given.

3

Grant Permissions to the New User

Grant all privileges on all databases to the user newuser so they can manage data. Use the SQL command GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost' WITH GRANT OPTION; and then run FLUSH PRIVILEGES; to apply changes.

MySQL

# Grant privileges to newuser
# Your code here

Need a hint?

Use GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost' WITH GRANT OPTION; and then FLUSH PRIVILEGES; to activate the permissions.

4

Verify User Connection

Test that the user newuser can connect to the MySQL server by logging in with the command mysql -u newuser -p and entering the password password123. Confirm the connection is successful.

MySQL

# Connect as newuser to verify
# Your code here

Need a hint?

Use the MySQL client command line to connect as newuser and enter the password when prompted.