Install and remove MySQL and simple MySQL operations on Ubuntu by Apt-get Way

The installation process:

First step: Open a terminal.

Step two: Enter the sudo apt-get install mysql-server and press ENTER to enter the password.

Step three: Terminal prompt "Do you want to continue?" [y/n] ". Enter Y and press ENTER

Fourth step: The software will automatically install and jump out of the following interface, require you to enter the root password of the MySQL, you can set a password, and then enter.

Fifth step: You will be prompted to confirm the password you just entered. Repeat the password again, and press ENTER.

Sixth step: If the following interface shows that MySQL has been installed successfully. You can also see that the MySQL version we installed is 5.5.

The seventh step: actually to the above step installation work has basically been done. Let's check to see if the MySQL database has been started. Enter Ps-ef|grep mysqld inside the terminal

You can see that the MySQL process number is 31115 (your computer may show a different process number than me).

Eighth step: Next visit MySQL database. In terminal input Mysql-u root-p, press ENTER. You are prompted for a password.

has entered the management interface of MySQL.

Nineth step: Enter show databases at the terminal;

Show all databases under current MySQL

Tenth step: Enter the use MySQL at the terminal;

Go to MySQL Database

12th step: Enter show tables at the terminal;

Show all tables under the current database

13th step: Exit the MySQL operating interface, enter quit on the terminal and press ENTER.

Process of uninstallation:

First step: Enter the following command in the terminal, sudo apt-get autoremove--purge mysql-server and press ENTER.

Step two: The process of uninstalling will prompt "Do you want to continue [y/n]?" "Enter Y, and press ENTER."

This will allow you to uninstall MySQL.

Install and remove MySQL and simple MySQL operations on Ubuntu by Apt-get Way