Issue to connection

HuaMin Chen
HuaMin Chen used Ask the Experts™
on
Hi,
Can I have details to enable relevant port below, due to error in MySQL DB?
5b.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Ryan ChongSoftware Team Lead

Commented:
check if you can enable it?

How to Open Ports
https://www.wikihow.com/Open-Ports
HuaMin ChenProblem resolver

Author

Commented:
I need the details to resolve current problem in Win 2012 server.
Durga Charan OjhaSr. System Administrator

Commented:
Do change the 3310 to 3306 and Test connection
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

HuaMin ChenProblem resolver

Author

Commented:
3306 is also not OK.
Tom CieslikIT Engineer
Distinguished Expert 2017

Commented:
Disable Firewall for test only on your Server and test again
It this will work just go to advance firewall settings and create inbound and outbound rule for this port
Durga Charan OjhaSr. System Administrator

Commented:
Need in brief details
MySql server is installed in the server machine and it's running or you get this error while installing it.
else MySql was running earlier and due to some changes its not running now?
HuaMin ChenProblem resolver

Author

Commented:
Such error is on nearly last step of MySQL setup.
 
I created TCP Inbound/Outbound rules on Firewall, on both port 3306 and 3310. But issue persists.
Sr. System Administrator
Commented:
If we can try clean setup again
Uninstall mysql
Delete mysql folders from Program Files and ProgramData
Reboot machine
then right click over installer - run as administrator to start the installation
Tom CieslikIT Engineer
Distinguished Expert 2017

Commented:
Make sure you can PING your Host name.
In your test you can test connection and it doesn't have to be because of port settings.
Double check your DNS settings or put hardcoded info about server name and IP into Host file, then test again
HuaMin ChenProblem resolver

Author

Commented:
Durga,
I already restored the current setup of MySQL but there is no way to run as Administrator below.

5c.pngTom,
Can I have more details to your advised way?
Tom CieslikIT Engineer
Distinguished Expert 2017

Commented:
1. Check if your server has only 1 IP
2, Ping your server name and check if will come back with right IP
3. Ping Your server IP -A and check if will come back with right name

Open HOST file as administrator in notebook and put your server name and IP address there

Test after
Durga Charan OjhaSr. System Administrator

Commented:
Please download and install this version MySql 8.0 - https://dev.mysql.com/downloads/file/?id=490395
If you can quickly check from services.msc - MySQL service is there or not
If you still get any error Please do share a screenshot of error after that
HuaMin ChenProblem resolver

Author

Commented:
Tom,
I would revert.

Durga,
As I need to work with hMailserver further, I would have to work with current 32-bit version of MySQL.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial