Hello MySQL

This Tutorial will show you how to create and deploy a simple MySQL server as well as some basic examples

 

Main Learning's

After following this tutorial you will learn how to:

• Download and install MySQL
• Create a MySQL Database
• Create a table
• Run insert, select, update, delete on records in a table
• Delete a table (drop)

 

Versions used:

• OS: Windows XP SP2
• MySQL 5.0.45

 

Common Issue:

• Antivirus or firewall was not disabled before installation. 

 

Tutorial Steps:

 

 1.      Go to the MySQL download web site: http://dev.mysql.com/downloads/ and press Download.

 

 

  

    2. Download your platform MySQL

 e.g. Windows ZIP/Setup.EXE (x86)

 

 

 

    3. Launch setup.EXE

 

 

 

    4. Keep clicking next until you encounter the “Read to Install the Program” screen

            

 

 

 

    5. Hit Install. After that you should see some screens followed by “Wizard Complete” screen. Click on Finish to launch MySQL Server

 

             

 

 

 

    6.  Choose “Standard Configuration” and click Next.

 

            

 

 

 

    7. In the MySQL Server Instance Configuration click Next.

 

            

 

 

 

 

    8. Enter chosen password in the screen. This password is always required to connect to MySQL server.

            

 

 

 

    9. Click Execute to launch MySQL server instance.

 

              

 

 

 

    9.1 If you have a virus scanner or a firewall enabled the below error is encountered. Disable the virus scanner or firewall and press Retry.

 

            

 

 

 

    10. Run MySQL command line client

            

 

 

 

 

    11. Enter the password on the prompt

 

 

    12. Type “create database university;” to create a database called university.

            

 

 

    13. type   USE university;

 

 

 

    14. type   CREATE TABLE student (

                        student_id INT NOT NULL AUTO_INCREMENT,

                        name VARCHAR(30),

                        score INT,

                        PRIMARY KEY (student_id) );

 

 

 

    15. type   INSERT INTO student VALUES (NULL, “John", 24);

 

 

 

 

    16. type    INSERT INTO student VALUES (NULL, “Mary", 23);

 

 

 

    17. type    SELECT * FROM student;

 

 

 

    18. type    SELECT * FROM student WHERE name=“John”;

 

 

 

    19. type    SELECT * FROM student WHERE score = 22;

 

 

 

    20. type    UPDATE student SET name="Victor" WHERE name="John";

 

 

 

    21. type    UPDATE student SET name=“Natalie” WHERE student_id=8;

 

 

 

    22. type    DELETE FROM student where name=“Victor”;

 

 

 

    23. type    DROP TABLE student;