Article From:https://www.cnblogs.com/niceletter/p/9969913.html

Today the company will deploy a system to the ECS server in Aliyun.

The database is not RDS. It needs to be installed by itself. I installed mariadb-10.3.10-winx64.msi.

My operating system is Windows Server 2012 R2

After installation,

Create User…. Set Password

OK 

 

Remote connection…

hehe  。。。。。

Suddenly found that port 3306 inbound rule was not configured.

Dispose

 

 OK  Discovered that it was still disconnected.

Look online.

Need to add bind-address= 127.0.0.1 in my.ini

Configure CMD and restart MySQL

net stop mysql

net start mysql 

After testing, we found that it was still a 2003 error…

Dizzy

After tossing around all afternoon, I found myself using Aliyun’s server.

Need to reconfigure the security group in the console

()*&@*……#&())——

Configuration Security Group

 

 

 

0.0.0/0 for full network access

After the configuration is completed,

Think it’s over.

Testing is still problematic.

telnet It’s never worked.

 

What does bind-address= 127.0.0.1 mean?

Isn’t IT bound to the local machine????

The time relationship has not been studied in detail. Then note it out.

Still restart MySQL

Once again telnet passes…

Summary: Do not seek medical treatment in disorder. If the service is not available, the port is open and can not pass.

Leave a Reply

Your email address will not be published. Required fields are marked *