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

The webpage cannot be opened because the div element lacks a closing tag

At first I thought it was a speed issue, so I late...

Node.js+express+socket realizes online real-time multi-person chat room

This article shares the specific code of Node.js+...

Design of image preview in content webpage

<br />I have written two articles before, &q...

Detailed explanation of JS array methods

Table of contents 1. The original array will be m...

MySQL index optimization: paging exploration detailed introduction

Table of contents MySQL Index Optimization Paging...

Teach you how to quickly enable self-monitoring of Apache SkyWalking

1. Enable Prometheus telemetry data By default, t...

Implementation of HTML command line interface

HTML Part Copy code The code is as follows: <!D...

Self-study of MySql built-in functions knowledge points summary

String functions Check the ascii code value of th...

Solve the problem that Docker pulls MySQL image too slowly

After half an hour of trying to pull the MySQL im...

A brief discussion on the principle of React two-way data binding

Table of contents What is two-way data binding Im...

js to realize payment countdown and return to the home page

Payment countdown to return to the home page case...