MySQL installation configuration

Installing MySQL on Ubuntu is very simple and requires just a few commands to complete.

1. sudo apt-get install Mysql-server

2. Apt-get Isntall mysql-client

3. sudo apt-get install Libmysqlclient-dev

During installation, you will be prompted to set a password or something, note that the settings do not forget that after the installation is complete, you can use the following command to check if the installation is successful:

sudo netstat-tap | grep MySQL

After checking with the above command, if you see a socket with MySQL in the Listen state, the installation is successful.

Log in to MySQL database by the following command:

Mysql-u root-p

-U means to select the login user name,-p indicates the login user password, the above command input will prompt for a password, then enter the password can log in to MySQL.

　　

then through show databases; You can view the current database.

We choose the MySQL database to do the next step, using the use MySQL command, display the current database form: Show tables

MySQL installation configuration