mysql Enable Remote connection (mysql Enable Remote access)

Updated: December 27, 2013 16:31:22 Author:

Open the MYSQL remote connection permission method, we refer to use it

Copy codeThe code is as follows:

         
// You are advised to set a fixed IP address
         
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"8.8.8.8" IDENTIFIED BY "root";
         
mysql> flush privileges;
         
// Modify the firewall
         
iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

Articles you may be interested in:

IDEA connection to mysql error again! Server returns invalid timezone. Go to tab an

This article mainly introduces the IDEA connection mysql and error! Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' prope problem, this article gives you a very detailed introduction through the form of graphics, the need of friends can refer to the next
2020-05-05
Centos7 Changes the password of a specified mysql user

This article mainly introduces Centos7 to modify the password of the specified mysql user, Xiaobian feel very good, now share with you, also give you a reference. Let's take a look.
2016-12-12
A summary of two ways to implement mysql auto-fill time

This article mainly introduces the mysql auto-fill time two ways to achieve the summary, has a good reference value, I hope to help you. If there are mistakes or incomplete areas, please feel free to comment
2022-11-11
Simple example of mysql sql statement performance tuning

This article mainly introduces the mysql sql statement performance tuning simple examples of relevant information, need friends can refer to the next
2017-06-06
Two query methods are available when the mysql query field type is json

This article mainly introduces the mysql query field type is json when the two query methods, this article through the example code to give you a very detailed introduction, has a certain reference value, need friends can refer to
2019-07-07
Optimize the description of query statements in the MySQL database

This article mainly introduces the optimization of MySQL database query statements, a very practical summary of experience, need friends can refer to the next
2014-07-07
mysql subquery (single-line subquery, multi-line subquery, multi-column subquery)

This article mainly introduces the mysql sub-query (single-line sub-query, multi-line sub-query, multi-column sub-query), the article through the example code is very detailed, for everyone's study or work has a certain reference learning value, need friends to study together with Xiaobian below
2023-06-06
MySQL implements several practical scenarios for the replace function

This article mainly introduces several practical scenarios for MySQL to implement the replace function. The article introduces very detailed examples of code, which has certain reference value for everyone's study or work. The friends who need it will learn together with Xiaobian below
2021-02-02
mysql 5.7.23 winx64 decompressed version installation tutorial

This article mainly introduces the mysql 5.7.23 winx64 decompression version installation tutorial in detail, has a certain reference value, interested partners can refer to it
2018-09-09
This topic describes how to modify the engine in mysql

Modify mysql engine to INNODB, you can use foreign keys, transactions and other functions, high performance.
2011-08-08