Preferred MySQL tools [closed]

Closed. This question is opinion-based. It is not currently accepting answers.

---

Want to improve this question? Update the question so it can be answered with facts and citations by editing this post.

Closed 8 years ago.

Improve this question

Hi what are the preferred mysql tools with professional developers. I am a recent computing gr开发者_如何转开发aduate 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.

---

This is the tool to generate MySQL queries. There you can find MySQL generator for different commands, like drop table, create table, rename database, create database etc.

---

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

---

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

---

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.

---

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

---

Probably

• Navicat
• phpMyAdmin

---

DB Forge Studio for MySQL

---

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

---

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.

---

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