Shulou(Shulou.com)06/01 Report--

Today, the editor shares with you the method of installing mysql on ubuntu. I believe many people do not know much about it. In order to let you know more about the method of installing mysql on ubuntu, I have summarized the following contents for you. Let's look down together. I'm sure you'll get something.

The method of installing mysql in ubuntu

First, execute the following three commands:

Sudo apt-get install mysql-serversudo apt install mysql-clientsudo apt install libmysqlclient-dev

After a successful installation, you can test whether the installation is successful by using the following command:

Sudo netstat-tap | grep mysql

The following message appears to prove that the installation was successful:

You can enter the mysql service with the following command:

Mysql-uroot-p your password

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 the exit, then go to the mysql service and execute the authorization command:

Grant all on *. * to root@'%' identified by 'your password' with grant option;flush privileges

Then execute the quit command to exit the mysql service, and restart mysql by executing the following command:

Sudo service mysql restart

These are the details of how to install mysql on ubuntu. For more information, please follow other related articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.