Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to install and use mysql in the Ubuntu system. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

1. Open the terminal and obtain the root permission

2. Enter:

Apt-get install mysql-serverapt-get install mysql-clientapt-get install libmysqlclient-dev

During installation, you need to enter "Y" where necessary to determine.

After the above three commands have been executed, to check whether mysql is installed successfully, enter the following command to view it:

Netstat-tap | grep mysql

If the situation shown in the following figure occurs, the installation is successful.

3. Realize remote control of mysql

(1) Edit the file / etc/mysql/mysql.conf.d/mysqld.cnf and comment out bind-address = 127.0.0.1

As shown in the following figure:

(2) execute authorization commands under mysql (authorize any remote computer to log in to the database)

Type your password in the terminal mysql-uroot-p

After entering mysql, type the following command:

GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' your password 'WITH GRANT OPTION

Then refresh the configuration information and type the following command on the terminal:

Flush privileges

Use exit to exit mysql when you are done.

4. Restart the mysql service after performing the above steps. The command is as follows:

Service mysql restart

The above is the editor for you to share how to install and use mysql in the Ubuntu system, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.