Install MySQL tutorial under Ubuntu18.04

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

Now set MySQL to allow remote access, first edit the file/etc/mysql/mysql.conf.d/mysqld.cnf:

sudo vi/etc/mysql/mysql.conf.d/mysqld.cnf

Comment out bind-address = 127.0.0.1:

Save exit and then enter the MySQL service to execute the authorization command:

Grant all on * * to [e-mail protected] '% ' identified by ' your password ' with GRANT option;

Flush privileges;

Then execute the QUIT command to quit the MySQL service and perform the following command to restart MySQL:

Service MySQL Restart

Now you can use Navicat to remotely connect to the MySQL service under Ubuntu under Windows:

OK, to here Ubuntu18.04 installed MySQL has been completed, this article reference from several blogs, pro-test available, sorted out.

Blog One: https://www.linuxidc.com/Linux/2016-07/133128.htm

Blog two: https://www.linuxidc.com/Linux/2017-06/144805.htm

Install MySQL tutorial under Ubuntu18.04