What is a good MySQL manager?

Question

On Windows, I use SQLyog. And I am new to Ubuntu.

Is there a mysql manager programs as good as SQLyog ?

score 10 · Answer 1 · answered Apr 10 '11 at 12:23

10

The repository contains the mysql-admin package which is a GUI tool for administrating MySQL. From the package's description:

GUI tool for intuitive MySQL administration

MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating.

MySQL Administrator integrates database management and maintenance into a single, seamless environment, with a clear interface.

MySQL GUI screenshot

answered Apr 10 '11 at 12:23

Lekensteyn

174,277

thanks , i will test it. I see it is defrecated to use Workbench http://dev.mysql.com/downloads/gui-tools/5.0.html – meotimdihia Apr 10 '11 at 12:58
@meotimdihia -> wrong that link is too old ... http://dev.mysql.com/downloads/workbench/5.2.html – hhlp Apr 10 '11 at 13:42
The project is EOL. See http://askubuntu.com/a/127924/446263 – jherax Oct 31 '16 at 18:23

Mark Robinson · Answer 2 · 2013-03-31T13:56:12.027

7

enter image description here You can use - Valentina Studio,the program is free. It works on 3 OS: MAC, WIN, LIN. It works as with MySQL, so with PostgreSQL, SQLite and Valentina DB.

I am pleased with this program.

edited Mar 31 '13 at 13:56

answered Mar 30 '13 at 13:40

Mark Robinson

71

score 5 · Answer 3 · edited Apr 13 '17 at 12:24

5

You can use SQLyog on Wine/LINUX with GNOME desktop see product page in TAB SQLyog on Wine/Linux

How do I install wine?

edited Apr 13 '17 at 12:24

Community

1

answered Apr 10 '11 at 13:07

hhlp

42,002

score 2 · Answer 4 · answered Jun 11 '13 at 09:59

2

On Windows I use Devart's MySQL GUI Manager ( http://www.devart.com/dbforge/mysql/studio/ ), but it doesn't work at Ubuntu. So I'll recommend to use WorkBench ( http://dev.mysql.com/downloads/tools/workbench/5.2.html )!

answered Jun 11 '13 at 09:59

StasM

21
1

score 1 · Answer 5 · edited Mar 30 '13 at 14:55

1

The MYSQL Administrator, which you can install in the Software Center, is a pretty good GUI management tool.

edited Mar 30 '13 at 14:55

Eliah Kagan

117,780

answered Mar 28 '12 at 09:00

Narendra Petkar

175

1

it has probably been disabled from The 12.04 LTS – Narendra Petkar Jul 07 '12 at 19:24

score 0 · Answer 6 · answered Jan 07 '20 at 13:21

0

I use Dbeaver on ubuntu. It is an eclipse style platform independent tool, which is very powerful and feature rich, and receives regular updates.

answered Jan 07 '20 at 13:21

Mubashar Abbas

111
4

score 0 · Answer 7 · answered Sep 29 '15 at 03:13

I use this tools and recommend this list for you.

MySQL Workbench (http://dev.mysql.com/downloads/workbench/)
HeidiSQL (http://www.heidisql.com/)
NaviCat

I love using MySQL Workbench because easier for me to manage mysql server, and the reverse/foward engineering are very good.

But when doing code, I prefer HeidiSQL which much simple and sleek. But NaviCat also are good tools to have. It help me to structure the complex sql query.

I hope this list and reason behind I use this tool can help you to decide and choose ;)

What is a good MySQL manager?

7 Answers7