Telnet MySQL appears: is not allowed to connect to this MySQL serverconnection closed by foreign host problem resolution

Sometimes when you telnet to a MySQL server, it appears:

Host ' 192.168.0.1 ' isn't allowed to connect to this MySQL serverconnection closed by foreign host.

This is because the MySQL database requesting the link only allows the server on which it resides, and it needs to set the allowed IP rights on the MySQL server as follows:

connection command side: 1. Connect to MySQL

Mysql-u root-p

2. Authorization

Grant all privileges on * * to ' root ' @ ' 192.168.0.1 ' identified by ' 123456 ';

Of course, if you want to give permissions to all IPs, this is the case:

Grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 ';

3. Immediate entry into force of the mandate

Flush privileges;

Then telnet remotely or connect to the MySQL database to succeed.

Reference

Telnet MySQL appears: is not allowed to connect to this MySQL serverconnection closed by foreign host problem resolution

Alibaba Cloud Hot Products
Elastic Compute Service (ECS)	Dedicated Host (DDH)	ApsaraDB RDS for MySQL (RDS)	ApsaraDB for PolarDB(PolarDB)	AnalyticDB for PostgreSQL (ADB for PG)
AnalyticDB for MySQL(ADB for MySQL)	Data Transmission Service (DTS)	Server Load Balancer (SLB)	Global Accelerator (GA)	Cloud Enterprise Network (CEN)
Object Storage Service (OSS)	Content Delivery Network (CDN)	Short Message Service (SMS)	Container Service for Kubernetes (ACK)	Data Lake Analytics (DLA)
ApsaraDB for Redis (Redis)	ApsaraDB for MongoDB (MongoDB)	NAT Gateway	VPN Gateway	Cloud Firewall
Anti-DDoS	Web Application Firewall (WAF)	Log Service	DataWorks	MaxCompute
Elastic MapReduce (EMR)	Elasticsearch