MySQL Forums
Forum List  »  Newbie

Re: MySQL Error Number 2003
Posted by: molo lo
Date: August 18, 2022 01:13AM

mysql> update mysql.user set host = '%' where user = 'root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

I just typed the above 2 statements but same error.
I can't enter my CentOS MySQL through my Windows 10 MySQL Query Browser.




Moreover, I can't telnet to the 3306 port of the CentOS MySQL server:

Microsoft Windows [Version 10.0.17134.112]
(c) 2018 Microsoft Corporation. All rights reserved.

C:\>telnet 10.1.10.130 3306
Connecting To 10.1.10.130...Could not open connection to the host, on port 3306: Connect failed

C:\>


Any idea>

Options: ReplyQuote


Subject
Written By
Posted
August 16, 2022 03:14AM
August 16, 2022 03:16AM
August 16, 2022 10:27AM
August 16, 2022 09:07PM
August 16, 2022 09:29PM
August 16, 2022 10:33PM
August 16, 2022 10:37PM
August 17, 2022 10:08AM
Re: MySQL Error Number 2003
August 18, 2022 01:13AM
August 18, 2022 10:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.