Solution to the failure of remote connection to MySQL database in Linux configuration

Solution to the failure of remote connection to MySQL database in Linux configuration

Today I have a question about configuring MySQL database under Linux for remote access. Baidu has a lot of information on this, but the methods are the same. I have tried them all but failed to solve them. I will record them here.

Step 1: Find bind-address = 127.0.0.1 in /etc/mysql/my.cnf

Add a "#" before this line to comment it out, or change it to: bind-address = 0.0.0.0

Allow any IP address to access; or specify the IP address that you need to access remotely.

Then restart mysql: sudo /etc/init.d/mysql restart

Step 2: Authorize users to connect remotely

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

The first line of command is explained as follows: *.*: the first * represents the database name; the second * represents the table name. This means that all tables in all databases are authorized to the user. If you only want to authorize a certain database or a table under a database, replace * with the database name and table you need. root: Grant the root account. “%”: Indicates that the authorized user IP can be specified, which means that any IP address can access the MySQL database. "password": the password corresponding to the assigned account. Replace the password with your root account password.

The second line of command refreshes the permission information, allowing the permissions we set to take effect immediately.

But in the end, it still cannot be accessed. At this time, it may be a problem with the firewall and MySQL port 3306.

I used the command netstar -a to query all ports but did not see port 3306. I used the command nerstat -an|grep 3306 but nothing was displayed. This means that port 3306 does not exist.

Log in to the Alibaba Cloud console, add a new rule in the cloud service security group, clone a rule and change the port number to 3306 of MySQL. The remote connection still fails again.

At this time, the console needs to restart the system to make the newly added rules take effect. After the restart, the connection still fails. At this time, the local navicat software connection returns an access denied error instead of the previous unable to connect error.

At this time, execute the second step above to authorize the user command again, and after restarting Apache MySQL, the connection is finally successful.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:
  • Tutorial on installing JDK Tomcat MySQL on Linux (remote access using Mac)
  • How to enable MySQL remote connection in Linux server
  • How to remotely connect to MySQL database under Linux
  • Tutorial on how to remotely connect to MySQL database under Linux system
  • Linux platform mysql enable remote login
  • Enable remote access rights for MySQL under Linux and open port 3306 in the firewall
  • Solution to the problem that the MySQL database on the Linux side of the virtual machine cannot be accessed remotely
  • How to install and set up Linux mysql command to allow remote connection
  • MySQL 5.7 deployment and remote access configuration under Linux

<<:  Use Javascript to develop sliding-nav navigation plug-in with sliding bar effect

>>:  How to use squid to build a proxy server for http and https

Recommend

How to use js to determine whether a file is utf-8 encoded

Conventional solution Use FileReader to read the ...

Why MySQL should avoid large transactions and how to solve them

What is a big deal? Transactions that run for a l...

React Principles Explained

Table of contents 1. setState() Description 1.1 U...

Why do select @@session.tx_read_only appear in DB in large quantities?

Find the problem When retrieving the top SQL stat...

Steps for Vue to use Ref to get components across levels

Vue uses Ref to get component instances across le...

JavaScript implements cool mouse tailing effects

After watching this, I guarantee that you have ha...

CentOS7 deployment Flask (Apache, mod_wsgi, Python36, venv)

1. Install Apache # yum install -y httpd httpd-de...

How to use Linux paste command

01. Command Overview The paste command will merge...

XHTML tutorial, a brief introduction to the basics of XHTML

<br />This article will briefly introduce yo...

Complete steps to enable gzip compression in nginx

Table of contents Preface 1. Configure gzip compr...

Example of Vue transition to achieve like animation effect

Table of contents Results at a Glance Heart Effec...

Detailed explanation of map overlay in openlayers6

1. Overlay Overview Overlay means covering, as th...