Jump to content


Photo

Linux GUI for MySQL


  • Please log in to reply
11 replies to this topic

#1 scootstah

scootstah

    Advanced Member

  • Gurus
  • 2,889 posts
  • LocationUSA

Posted 22 January 2013 - 11:39 AM

MySQL Workbench works fine in Windows, but it's a heap of crap in Ubuntu. You can't select multiple data rows, it's slow, it crashes every 5 minutes...

Is there a good alternative? I like the functionality and features that MySQL Workbench offers, but I need something a bit more stable. The features I'm looking for are:
- Connect via SSH Tunnel
- A nice query executor
- Able to save SQL snippets (not so important, but nice)

What do you guys use?
while(!$succeed = try());

#2 Philip

Philip

    Phailip

  • Staff Alumni
  • 4,750 posts

Posted 22 January 2013 - 11:46 AM

I use MySQL workbench, mainly on windows. It's not the best that's for sure.

I'm interested in seeing other options as well.

#3 shlumph

shlumph

    Advanced Member

  • Members
  • PipPipPip
  • 576 posts
  • LocationNew Hampshire

Posted 22 January 2013 - 01:05 PM

Can't say I've ever tried it under Ubuntu, but NetBeans has MySQL support:
http://netbeans.org/...cles/mysql.html (old article, but you can catch the drift from the videos)

I'm pretty sure Eclipse has MySQL integration too.
whether you think you can, or can't, you're right -HF
Visit my website or github

#4 premiso

premiso

    Trollololol

  • Members
  • PipPipPip
  • 6,969 posts
  • LocationHairy Beaverville

Posted 22 January 2013 - 01:16 PM

I use bash  :)

I know of http://sourceforge.n...ojects/mysqlcc/  which works decent. The workbench I just hated. The MySQLCC program was the best I found, but I still prefer to use the CLI. 

Edited by premiso, 22 January 2013 - 01:16 PM.

Did I assist you? Feeling like contributing to my gaming addiction?

Assist with my gaming addiction! | Free Flash Games | lxt Article Site

#5 kicken

kicken

    Wiser? Not exactly.

  • Gurus
  • 2,731 posts
  • LocationBonita, FL

Posted 22 January 2013 - 07:51 PM

You could go the route of a web-based app also, I like SQL Buddy.
Recycle your old CD's, don't trash them!
Did I help you out?  Feeling generous? I accept tips via Paypal or Bitcoin @ 14mDxaob8Jgdg52scDbvf3uaeR61tB2yC7

#6 RobertP

RobertP

    Advanced Member

  • Members
  • PipPipPip
  • 288 posts

Posted 23 January 2013 - 11:58 PM

had the same question a few months ago, and i just installed the newest version of phpmyadmin and have not looked back.
u tha king Pikachu2000!!

#7 mark_r

mark_r

    Newbie

  • New Members
  • Pip
  • 1 posts

Posted 01 April 2013 - 08:25 AM

You can use Valentina Studio http://www.valentina...tudio-overview. Works on Linux,  Mac and Win.  14 Feb 2013 in the 5.0 version added support of mySQL/mariaDB , as well as, SQLite, PostgreSQL. It is FREE. Includes not only db management but powerfull reports that work again on 3 OS.

 

valentina5interface_1_765x506.png



#8 jazzman1

jazzman1

    Advanced Member

  • Gurus
  • 2,678 posts
  • LocationMississauga, Canada

Posted 01 April 2013 - 10:05 AM

MySQL Workbench works fine in Windows, but it's a heap of crap in Ubuntu. You can't select multiple data rows, it's slow, it crashes every 5 minutes...

 

Hm..... that's very weird. I've never have a problem with it for one year on my CentOS6.x (Gnome) machine. I thing that problem appears because of yours linux graphical environment.


Edited by jazzman1, 01 April 2013 - 10:06 AM.


#9 jazzman1

jazzman1

    Advanced Member

  • Gurus
  • 2,678 posts
  • LocationMississauga, Canada

Posted 01 April 2013 - 12:21 PM

I don't know why you cannot retrieve the content from multiple tables and databases.

 

Unfortunately, there is no way to test it how this wonderful program works in windows ( I have only windows 95)

 

See my log, the last time that I restarted the mysql-workbench was at March 28.

 

Log:

[jazzman@localhost log]$ ps aux | grep /usr/bin/mysql-workbench
jazzman  31356  0.0  0.0 106096  1276 ?        Sl   Mar28   63:27 /bin/bash /usr/bin/mysql-workbench
jazzman  32504  0.0  0.0 103244   844 pts/0    S+   12:57   0:00 grep /usr/bin/mysql-workbench

mysql_workbench.png

 

 

 



#10 Sergei_Kharchenko

Sergei_Kharchenko

    Newbie

  • New Members
  • Pip
  • 1 posts

Posted 12 July 2013 - 02:19 AM

I don't think that MySQL WorkBench is very good for Windows... Read the article about its more professional and functioonal alternative: http://blogs.devart....-for-mysql.html

So for Windows I use dbForge Studio for Mysql ( http://www.devart.co...e/mysql/studio/ ), and for Linux I prefer Valentina ( http://www.valentina...studio-overview )



#11 anikwa

anikwa

    Newbie

  • Members
  • Pip
  • 7 posts
  • LocationNorthern Ireland
  • Age:23

Posted 27 November 2013 - 05:16 PM

I've not had any issues with MySQL Workbench in either Windows or Linux.


"Am I an alien? I'm crashing down on you!" - Gilby Clarke


#12 sathishnadu

sathishnadu

    Newbie

  • New Members
  • Pip
  • 4 posts

Posted 14 March 2014 - 07:43 AM

i have used SQLyog for this. But it uses wine. The UI is very intutive.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com