MySQL 8.
x Installation Guide (Windows)
Class XII Computer Science
Step 1: Download MySQL Installer
1. Open your web browser.
2. Go to:
[Link]
3. Click MySQL Installer for Windows.
4. Download mysql-installer-community-*.msi.
o Recommended: Download the Full Installer if your internet connection is slow.
o Otherwise, you may use the Web Installer.
Step 2: Run the Installer
1. Double-click the downloaded installer.
2. Click Yes if Windows asks for permission.
Step 3: Choose Setup Type
Select:
Developer Default (Recommended)
This installs all the required components automatically:
MySQL Server
MySQL Workbench
MySQL Shell
MySQL Connectors
Click Next.
Step 4: Install Components
1. Click Execute.
2. Wait until all components show Complete.
3. Click Next.
Step 5: Configure MySQL Server
Type and Networking
Config Type: Development Computer
Connectivity: TCP/IP
Port: 3306 (Leave the default)
Click Next.
Authentication Method
Select:
Use Strong Password Encryption (Recommended)
Click Next.
Root Account
Create a password for the root user.
Example:
Username: root
Password: root123 (Example only)
Note: Choose your own password and remember it carefully.
Click Next.
Windows Service
Keep the default settings:
Service Name: MySQL80
Configure MySQL as a Windows Service
Start the MySQL Server at System Startup
Click Next.
Step 6: Apply Configuration
1. Click Execute.
2. Wait until all steps show a green check mark.
3. Click Finish.
MySQL Server is now installed successfully.
Step 7: Verify the Installation
Open MySQL Command Line Client.
When prompted, enter the root password that you created.
After logging in, type:
SHOW DATABASES;
If the installation is successful, you should see databases similar to:
information_schema
mysql
performance_schema
sys
Step 8: Install MySQL Connector for Python
Open Command Prompt and type:
pip install mysql-connector-python
If pip is not recognized, use:
python -m pip install mysql-connector-python
or
py -m pip install mysql-connector-python
Step 9: Test the Python Connector
Open Python IDLE and run:
import [Link]
print("MySQL Connector Installed Successfully")
If no error appears, the connector has been installed correctly.
Step 10: Test Python–MySQL Connection
Run the following program in Python IDLE:
import [Link]
con = [Link](
host="localhost",
user="root",
password="YOUR_PASSWORD"
)
print("Connected Successfully")
Replace YOUR_PASSWORD with the password you created during installation.
If the program prints:
Connected Successfully
your Python–MySQL interface is working correctly.
Common Errors and Solutions
Error Solution
ModuleNotFoundError: No module named Install the connector using pip install mysql-
'mysql' connector-python.
Access denied for user 'root' Check that you entered the correct root password.
Can't connect to MySQL server Make sure the MySQL80 service is running.
pip is not recognized
Use python -m pip install mysql-
connector-python instead.