A visual MySQL tool for Ubuntu

Question

Hi all

I have recently installed Ruby on Rails on my new Ubuntu machine (first time for me) and i was working through a demonstration on setting up a sample blog.

Basically, i came to the part of setting up the mysql database and would rather use a visual MySQL tool to do this rather than command line.

What is best to use? and how do o get it?

Thanks all.

Answer 1

sudo apt-get install phpmyadmin

Answer 2

Webyog is a good non-free alternative

Answer 3

I use navicat and the native mysql gui admin and query browser. they run perfectly well under ubuntu, although not native to it.

Answer 4

sudo apt-get install mysql-admin mysql-query-browser

Both of these are desktop apps.

Answer 5

I find SQuirreL SQL Client very appealing.

Answer 6

PHPMyAdmin is definitively a friend there.

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 55 languages. GPL License information.

It is a great web-based tool. To unstall it, simply run the following command:

sudo apt-get install phpmyadmin

Answer 7

You also have DBDesigner 4.

Answer 8

Thanks all.

I will try either the phpMyAdmin as i have had experience of using it in the past.

I still have a bit of a way to go to understand how to connect to the 3 database types that RoR uses but we shall see.

Cheers

Answer 9

Another alternative:

SQLBuddy

Answer 10

I'm using SQLyog under Wine and it works like a charm.

sudo apt-get install wine
wget http://www.webyog.com/downloads/SQLyog-8.6.1-0Trial.exe
wine SQLyog-8.6.1-0Trial.exe

Also keep in mind that in Rails to create your db you can do a

rake db:create

Answer 11

I recommend Navicat.

It certainly is one of my main tools in maintaining K-12 education e-learning sites ... I never had a warm fuzzy feeling about phpMyAdmin and other tools in this category never measured up to Navicat.

also, Support has always been A1 over the years as well.

Answer 12

"MySQL Workbench" is also quite nice.

Answer 13

I recommend RazorSQL. I use it on Ubuntu, Redhat, Mac, and Windows machines.