MySQL client for Linux

simplecode2011-09-19 22:41:35

MySQL

simplecode, 2011-09-19 22:41:35

Hello Habr!

Available: Ubuntu Linux, mysql client, standard Gnome terminal.
Want: SQL manager, similar to the mysql client, but with syntax highlighting and a convenient mechanism for editing queries.

PS MySQL Query Browser - no good ...
PPS Who uses what?

Answer the question

In order to leave comments, you need to log in

16 answer(s)

Alexander Maslov, 2011-09-20
@drakmail

navicat. Lite version is free.

Alexey Sidorov, 2011-09-19
@Gortauer87

mysql workbench is, but it is very crooked. The best one I've seen is Sequel-Pro but it's Makovsky.

Sergey, 2011-09-19
@butteff

I use phpmyadmin, though it's a web interface crap, but I'm used to it and I like it.

death_claw, 2011-09-20
@death_claw

For example, I wrote a utility for myself in java.
If you need everything here
Ubuntu Debian
github.com/strelok1111/MysqlJavaCat/raw/master/MysqlJavaCat.deb
Windows
github.com/strelok1111/MysqlJavaCat/raw/master/Win/mysqljavacat_win_dist.exe
It's quite simple, but I'm seriously driven with autocompletion. I'm comfortable.
If you like write a couple of lines.

Sergey Savostin, 2011-09-21
@savostin

www.heidisql.com/ via Wine

Anatoly, 2011-09-19
@taliban

"SQL manager similar to mysql client"
"convenient query editing mechanism"
As far as I understand you need a console client? As far as my memory serves me, the console and a convenient editing mechanism are two different things. The console is very convenient for typing, but it is bad for editing.

Ivan Komarov, 2011-09-19
@FreeTibet

I used the free version under vine from these guys .
But it is buggy, an infection, but in general it is convenient.

asm0dey, 2011-09-20
@asm0dey

Squirrel?

png, 2011-09-20
@png

netbeans - for complex queries
+
sometimes - phpmyadmin
just look at the data

mrspd, 2011-09-21
@mrspd

aqua data studio? not?

zizop, 2011-09-21
@zizop

I used Navicat in Wine. Except for the screen flashing at startup, it's a great thing. Particularly pleased with the Data Transfer mode for synchronizing servers. In case of any heisenbugs, it updates the local database in a few minutes. And on the little things - I use phpmyadmin.

charon, 2011-09-22
@charon

Under Windows, I really liked Navicat, from the free HeidiSQL. There is nothing similar under Linux, because MySQL WorkBench is for design, and most often the usual mysql console. Didn't find anything better.

nmike, 2011-09-28
@nmike

I've been using this for a very long time now . Yes - Windows, but under Vine it works fine. tested for years! work with him.
if you feel sorry for the money - then here is the free version . the most important difference from the paid one is the absence of tunnels to the servers, but you are on ubuntu - it's very easy to set up with handles :)

iSergium, 2014-08-27
@iSergium

I also wondered for a long time about the SQL client, temporarily but continuously using phpMyAdmin. and trying different clients along the way. Under Windows I use only HeidiSQL. I decided to try to use it on Linux from under Wine. Works great, search is no longer relevant :-)

Sergey, 2019-11-07
@begemot_sun

I have been using WebYog Community Edition for many years, if not dozens.

alexeytru, 2020-10-30
@alexeytru

Data Grip by JetBrains