MySQL server communications / commands via a TCP/IP client???

I have a MySQL server on a network and I have a TCP/IP client that can send text and receive text strings.

Is it possible to have the TCP/IP client send a connection command, then and insert command?
keith1001Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
No.  MySQL has it's drivers and communications protocols.  You can not connect directly to it with something like telnet.  You can, in theory, connect to the server with telnet or SSH and run the 'mysql' command line program.

If you are using a programming language, you can use the appropriate MySQL driver and connect that way.  See the list here: https://www.mysql.com/products/connector/
0
F PCommented:
You need to be able to connect on port 3306 using the "TCP/IP Client" you mentioned. I don't know what specifically that "Client" is, but if it supports any of these connectors listed:

https://www.mysql.com/products/connector/

... then sure. I don't see why it couldn't. You might also want to checkout Mirth Connect:

https://www.mirth.com/Products-and-Services/Mirth-Connect

Which only charges for support, but is designed to bring interop to differing systems into a single java interface. The community edition and your own code is free if there isn't already something built to work.
0
keith1001Author Commented:
@dave that could possibly work.  My client app though is limited, it can only send strings and receive strings.

So are you saying I could just connect, then send a MySQL login command(String) and then wait a few seconds and then send the INSERT sql command (string)?
0
keith1001Author Commented:
@dave, I tried Telnet but got bergish (I assume binary) back and could not do anything at all.
0
Dave BaldwinFixer of ProblemsCommented:
That is correct, you can Not connect directly to MySQL.  You need to login to that machine with a valid user login and run the 'mysql' command line program (which is a utility program, not the server daemon).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.