[root @ xaiomu mysql] # mysql -u root -p - h192.168.0.176
Enter the password:
ERROR 2003: (HY000) Can 't connect to MySQL server on' 192.168.0.176 '(113), leaders help me to solve it, I find the Internet doesn't work

CodePudding user response:

127.0.0.1 try

CodePudding user response:

Check services have started: systemctl status mysqld

If is the remote machine, see if mysql server opened the firewall, port has been banned

CodePudding user response:

reference 1/f, emperor royal thunder response:

127.0.0.1 try

No, I want to connect my virtual machine,

CodePudding user response:

refer to the second floor small wolves reply:

did check service activation: systemctl status mysqld

If is the remote machine, and see that the mysql server opened the firewall, port is banned

Can't find the service

CodePudding user response:

On the virtual machine, that is, local mysql server using root login database, select the user the table, look at the root of the host field is %, if not is to limit the root user can only log on locally, to modify the host value of root % can remote login, reference the: https://www.cnblogs.com/liuhaidon/archive/2019/09/12/11511129.html

CodePudding user response:

reference 4 floor qinhdxioabai response:

Quote: refer to the second floor small wolves response:

did check service activation: systemctl status mysqld

If is the remote machine, and see that the mysql server opened the firewall, port is banned

Can't find the service

You don't have a successful installation?
In the mysql server running on?

To check the port 3306 have been occupied, what is the process of occupied

CodePudding user response:

Mysql default just allow local access, if you want to use across the host access, you need to use the grant authorization, specific to baidu,

CodePudding user response:

The

refer to the original poster qinhdxioabai response:

[root @ xaiomu mysql] # mysql -u root -p - h192.168.0.176
Enter the password:
ERROR 2003 (HY000) : Can 't connect to MySQL server on' 192.168.0.176 '(113), leaders help me to solve it, the way I find on the Internet doesn't work

Using the pagoda LINUX panel, install deployment is very convenient,