I'm looking for a way to use something else than PHPmyadmin. Are there any tools out there that can let me do this?
-
1For what purpose, filezilla is a file transfer program, are you looking for something to copy databases, or a general purpose database management environment like PHPmyadmin? Not sure about the reference to FileZilla, very disjointed. – Orbling Jun 29 '11 at 23:38
-
What does Filezilla, an ftp client, have to do with MySQL tables? Did you mean phpMyAdmin? – James Allman Jun 29 '11 at 23:38
-
Right, so Filezilla has nothing to do with databases, but this question did help me track down Workbench when a colleague described it as "Filezilla for databases" and couldn't remember the name. – Eligos Nov 30 '16 at 15:51
7 Answers
I use and recommend Toad.
It also has lots of import/export features that come in handy for backing up and restoring you databases.

- 13,672
- 12
- 76
- 124
You could use a program like PuTTY and connect to your server (or just open a command line or terminal if you're testing on localhost) and use mysql
directly.

- 218,210
- 55
- 464
- 476
I recommend DbVisualizer. It supports a number of databases including MySQL. It runs on Linux, OS X and Windows.
(source: dbvis.com)

- 21,988
- 13
- 81
- 109

- 40,573
- 11
- 57
- 70
I'll throw a couple more choices at you:
MySQL Workbench - http://wb.mysql.com/ - Developed by the MySQL Team SQLyog - http://www.webyog.com/en/ - I use the community version of this mostly, the pop-up when you open and close it are a bit annoying but I like the interface more than the others I've tried

- 799
- 2
- 10
- 24
-
I forgot to mention - both of the ones I mentioned are free; not sure if this is a consideration for you but it's worth mentioning – ollie Jun 29 '11 at 23:44
I'm currently using MySQL Workbench, it's free and you can use it on Linux and Windows. It has a beautiful and very intuitive interface. I use it mainly for database modeling but the server administration tools are great.
Screenshots here

- 10,002
- 11
- 54
- 83