MySQL cannot connect remotely. The user has been authorized.

my authorization command is

grant select on *.* to  "user_name"@"%" identified by "password";

navicat
pingIPpingtelnet3306

3306IP

I hope someone can see this problem and take a look at it for me. Thank you.

Centos mysql linux

Mar.03,2021

Please check whether the firewall opens the port
as mentioned above, Ali CVM, you need to set up a network security group. Open port

this question is asked to colleagues, which is not really a problem. Because I am using Aliyun's server, it is not enough to configure it on the server. I also need to configure a whitelist on Aliyun's website. If you have an Ali cloud server used by your partner, remember to configure the whitelist on the Ali cloud when you see it. If I didn't use Aliyun or my own virtual machine, I could have authorized the above operation successfully.

Previous: MySql queried two fields and compared them in the where condition. One of the fields could not be read.

Next: About the URL of WeChat Mini Programs uploading and downloading files

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b367fe-2b797.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b367fe-2b797.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?