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?
Subject
Written By
Posted
MySQL Error Number 2003
August 16, 2022 03:14AM
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.