CODEWITHSUNDEEP
mysqldatabaseremote-access
Scott
Scott

Reputation: 4200

Client to access and edit a MySQL database remotely

So I have been given the host, username, and login information for a MySQL Database. I need a client that I can use to log in to the Database remotely and create/update tables and edit all the data.

I found the MySQL Administrator client provided by them, but it seems you can do everything BUT edit the actual data with it.

Is there anything like this?

Would I be able to use SQL Server Express (or something similar), to connect to a remote server online and do all of this?

Upvotes: 1

Views: 4222

Answers (4)

JYelton
JYelton

Reputation: 36512

I highly recommend SqlYog Community Edition which inkedmn also mentioned. It handles database administration and query building, and similar enough to SQL Server Management Studio that you won't feel completely lost.

Upvotes: 0

jamesaharvey
jamesaharvey

Reputation: 14281

MySQL Workbench works great for me. It allows me to connect to some remotely hosted databases that I have via ssh.

Upvotes: 0

brettkelly
brettkelly

Reputation: 28205

If you're using OS X or Linux, you can install the mysql client and connect via the console. There are plenty of GUI clients for OS X and Windows (SqlYOG is a good, free one that I've used), just search Google for "mysql client ".

Upvotes: 1

chris
chris

Reputation: 9993

with the mysql administrator, you normally get the mysql query browser, which sounds like what you want :)

Upvotes: 1

Related Questions