0

I managed to get working Apache and everything's fine. Got MySQL running, which is nice. But then it turned out that I had to use terminal for all the SQL commands I had to put inside. I'm not close to that good to manage database by commands. So I wanted to use phpmyadmin, which prompted thousands errors and I can't even look into a table I just set up.

Does somebody know Ubuntu friendly MySQL database manager?

4 Answers 4

4

Universal database managers
a) DBeaver

wget -c http://dbeaver.jkiss.org/files/dbeaver_3.4.5_i386.deb
sudo dpkg -i dbeaver_3.4.5_i386.deb
sudo apt-get install -f

b) Valentina Studio

wget -c https://www.valentina-db.com/en/studio/download/current/vstudio_x64_lin-deb?format=raw
sudo dpkg -i vstudio_5_lin.deb
sudo apt-get install -f
4
  • Valentia, looked great, but it's not, that, it's no where as easy as phpmyadmin. I managed to create database and then I wanted to create table and I was doomed by my stupidity. For second. DBeaver, I managed to install him through terminal, as your commands suggested, but I couldn't find him, also through dash.
    – RikTelner
    Sep 2, 2014 at 16:52
  • type in terminal whereis dbeaver. It will localte your binary. /usr/share/dbeaver/dbeaver
    – matepal297
    Sep 2, 2014 at 17:12
  • "dbeaver:" is output.
    – RikTelner
    Sep 3, 2014 at 11:53
  • The download link for valentina-db is no more working.It might have been changed. Jun 16, 2017 at 12:43
2

It seems that the question is not about the category "GUI clients that make writing SQL statements easier", but "clients that avoid SQL or generate it for you".

So, relevant products would have wizards, or query builders, or table builders, or QBE.

phpMyAdmin has already been excluded, and MySQL Workbench has already been mentioned.

Non-WINE possibilities are

  1. SQLeo Visual Query Builder (requires Java)

  2. Open Office Base OpenOffice Base website- creating tables

  3. Adminer Adminer offical website (requires php).

I am not a user of these products, I am only suggesting that they might fit the question.

1
  • Thanks for your answer. It would be more useful if you could elaborate a little more about the three options you have given.
    – ankit7540
    May 26, 2016 at 8:51
1

You can try Mysql Workbench:

sudo apt-get install mysql-workbench

This lives in universe, so you have to enable universe repository for that to work. That said, if you are going to code anything (esp. SQL), you will need to get used to command line.

2
  • "That said, if you are going to code anything (esp. SQL), you will need to get used to command line.", oh no...
    – RikTelner
    Sep 2, 2014 at 17:07
  • I tried MySQL Workbench already. It's not really a GUI, it's more like, just GUI to connect and then type it in. I know how to login through terminal already and list databases.
    – RikTelner
    Sep 2, 2014 at 17:08
0

There's also SQuirreL SQL.

It requires Java, so you might need to run first:

apt-get install openjdk-7-jre

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .