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

This article will explain in detail how mysql allows remote connection to the database. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

How does mysql allow remote connection to the database

1. First open a command prompt and execute the mysql-u root-p command

two。 Execute a command

Grant all privileges on *. * to root@ "xxx.xxx.xxx.xxx" identified by "password"

3. Finally, execute the command to refresh the permissions.

Flush privileges

MySQL is a relational database management system developed by the Swedish company MySQL AB and belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software. MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

About how mysql allows remote connection to the database to share here, I hope the above content can be of some help to you, can learn more knowledge. 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.