Solved

Is there a command to see if mysql is reachable LAN,WIndows

Posted on 2016-08-24
3
85 Views
Last Modified: 2016-09-05
I am in a LAN and i have a program wat need to make a connection to an SQL server but it does not work
Is there a command in a windows 7 system without MySQL if the MySQL server(on Windows 7) is reachable  

Thanks Danny
0
Comment
Question by:Danny Kon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
Andy M earned 500 total points
ID: 41768758
It would be best using a mysql command to test the connection as you should be able to get more detailed error messages, but some of the more simple tests possible would be:

Try pinging the machine the SQl instance is located on.

Ensure MySQL is running on the specified port 3306 i.e. it has not been modified.

Ensure that the either PC is not blocking inbound connections on that port. If it is, add a firewall exception to allow connections on port 3306. (Or if a test environment and the network is secure, you could disable the Windows firewall altogether to rule that out as a problem).

I'm not aware of any other command that can be run from a base Windows system to test mysql connectivity.
0
 
LVL 6

Author Comment

by:Danny Kon
ID: 41769212
Andy,
"
It would be best using a mysql command to test the connection as you should be able to get more detailed error messages"

Can I run this commands without installing a version of MySQL?

I ping the system and is giving reply also there is an exception on the firewall port 3306 and i grant all privileges on the MySQL DB
But i dont get any connection to the MySql DB

Thx for helping

Danny
0
 
LVL 13

Expert Comment

by:Andy M
ID: 41777995
I believe you'd need to install mysql to gain access to the commands needed. The only other way I can think of doing it is via php scripting but for that to work you'd need to install a web hosting environment with PHP which will be just as time consuming.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question