3

I'm looking for a way to use something else than PHPmyadmin. Are there any tools out there that can let me do this?

John Doe
  • 3,559
  • 15
  • 62
  • 111
  • 1
    For 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 Answers7

2

I use and recommend Toad.

enter image description here

It also has lots of import/export features that come in handy for backing up and restoring you databases.

Steve Robbins
  • 13,672
  • 12
  • 76
  • 124
1

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.

Ry-
  • 218,210
  • 55
  • 464
  • 476
1

Yes there are many. Here are the best ones I have found.

On Windows

On Mac:

Other:

  1. DB Ninja
Colum
  • 3,844
  • 1
  • 22
  • 26
1

I recommend DbVisualizer. It supports a number of databases including MySQL. It runs on Linux, OS X and Windows.

DbVisualizer Screenshot
(source: dbvis.com)

Glorfindel
  • 21,988
  • 13
  • 81
  • 109
James Allman
  • 40,573
  • 11
  • 57
  • 70
1

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

ollie
  • 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
1

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

marcio
  • 10,002
  • 11
  • 54
  • 83
0

SequelPro is great on Mac OS. Then, I use Navicat on Windows.

Josh
  • 8,082
  • 5
  • 43
  • 41