Preferred MySQL tools

Question

Hi what are the preferred mysql tools with professional developers. I am a recent computing graduate and have used the query browser and administrator from mysql throughout university and i have found them to be very useful.

I start a new job in a couple of weeks though as a web developer and was wondering whether they would be exepcting me to use the command line or some other mysql tools.

What do the professional developers generally use for interacting with mysql databses i.e. creating new schemas, tables etc.

Answer 1

mysqladmin should be sufficient for most of the tasks if not all of them.

Answer 2

Probably

• Navicat
• phpMyAdmin

Answer 3

For the Mac for development I use Querious. The application is very well written and supports connecting to local and remote databases.

Answer 4

Both of the tools you point out are good, and they would probably expect you to have some familiarity with them. Usually I will use a tool such as Query Browser or pgAdmin (for PostGreSQL) to run simple queries.

Once you have more experience you might find the command-line tools helpful as well. It's only going to help you by learning them.

Answer 5

DB Forge Studio for MySQL

Answer 6

For windows, HeidiSQL is fantastic. It might work on Linux through Wine, but I've never tried it.

Answer 7

I occasionally use MySQL Workbench, as it can help speed up schema design (and the price is right). A cursory knowledge of phpMyAdmin is useful as it is often the admin tool of choice on web hosting servers. Most of the time, however, I just use the command line interface from Linux.

Understanding what goes on beneath the GUI is a very useful (dare I say essential) skill to have. Just look here on SO, where you'll find a vast number of SQL scripts that would be difficult to explain or implement if a GUI had to be factored in.

The CLI is available almost everywhere. If you ever have to work on a computer other than your own, be it on site or in your office, you can be fairly certain that CLI access will be available. The same cannot be said for your GUI of choice.

Answer 8

For most big companies, you usually use Microsoft Visio to develop and plot the database as well as the web layout.

Answer 9

SQLyog is what I turned to after trying to use HeidiSQL. I liked HeidiSQL but I loved SQLyog. There is a free version somewhere.