MySQL Forums
Forum List  »  Newbie

MySQL Error Number 2003
Posted by: molo lo
Date: August 16, 2022 03:14AM

Hi,
I just setup my MySQL database as follow:
CentOS 7
MySQL database

I could login it locally:

$ sudo mysql_secure_installation

However, I got the following error messages when I tried to login the database server from my Windows 10 MySQL Query Browser:

got "MySQL Error Number 2003"
Can’t connect to MySQL server on ‘xx.xx.xx.xxx’ (yyyy)


Then I created a MySQL login user:

CREATE USER 'userabc'@'%' IDENTIFIED BY '------------';
GRANT SELECT ON mysql.* TO 'userabc'@'%';

But same error from Query Browser.

I can use Query Browser to connect to all our company's Windows MySQL servers.
But Linux MySQL server, this is the first time.


Any idea?

Options: ReplyQuote


Subject
Written By
Posted
MySQL Error Number 2003
August 16, 2022 03:14AM
August 16, 2022 03:16AM
October 11, 2022 01:34AM
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
August 18, 2022 01:13AM
August 18, 2022 10:02PM


Sorry, only registered users may post in this forum.

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.