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

This article will explain in detail how to cancel the native binding restriction of MySQL database in Ubuntu. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Cancel the native binding restriction of MySQL under Ubuntu

There is a problem: in the Ubuntu system, a MySQL account is added to give the database full permission to operate

And allow the database to be linked from outside

However, the MySQL database cannot be accessed remotely.

Reason: in Ubuntu systems, the default installation of MySQL restricts local access to the database

Solution:

Remove native binding restrictions on MySQL databases

Nano / etc//my.cnf # Edit configuration file

Find bind-address = 127.0.0.1

Change to www.2cto.com

# bind-address = 127.0.0.1

Ctrl+o # Save configuration

Ctrl+x # exit

So much for sharing about how to cancel the native binding restriction of MySQL database in Ubuntu. I hope the above content can be helpful to you and you can learn more. If you think the article is good, you can share it for more people to see.

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.