CODEWITHSUNDEEP
mysqlwindows
dts
dts

Reputation: 125

How do I connect to mySQL database as a (Windows) client?

Okay, I am not dumb just ignorant. I have got mySQL Server working and am able to connect to my database with ADO on the server. Now I am trying to connect from a client computer. After searching and reading MANY Google hits (most from Stack Overflow) I finally concluded that the only easy path to this is to install the whole huge mySQL server package on the client computer (installing just the Client option fails completely).

But with this mess I can only connect to the same schema on the client computer; that is, it is just acting like a server and not connecting to my server-side database at all. How do I do it? I would love to just install something thin on the client side, but nobody seems to be telling how to do it for Windows. I am willing to keep the bloated server install on the clients because I am desperate, but how do I do that?

Upvotes: 1

Views: 6235

Answers (2)

mm759
mm759

Reputation: 1424

I recommend SQuirrel SQL. It works with the major database management systems. This is how to configure a connection. You need a MySQL JDBC-driver. It a jar-file. I simply dropped it in the lib-directory of SQuirrel SQL.

An alternative to SQuirrel SQL for MySQL is HeidiSQL.

Upvotes: 0

john elemans
john elemans

Reputation: 2666

You can connect with various tools. I suggest starting with MySQLWorkbench (http://www.mysql.com/products/workbench/).

If you want to connect from code, you need only have the proper library for the language you are coding in. They are called mySQL connectors. You can find them here (https://www.mysql.com/products/connector/). With the connector in your app, you can make api calls to connect to and access the database.

Upvotes: 1

Related Questions