SQLyog is a very powerful and efficient Mysql Database Client. You can connect to Local as well as Remote Mysql Databases. You cab create Databases, tables, edit them and insert data to them. Its makes database administration a seamless experience, helping you to utilize your more time and effort. Review collected by and hosted on G2.com.

It needs to be installed on system, unlike phpmyadmin which runs in browser as a web application. Review collected by and hosted on G2.com.

It stores data in a very simple format rather than complexing it and data can be easily found in it at the time of need.You can store a number of data of different projects but still it stores it in a convenient nested folder format which makes searching easy.Even if you have done easily tick and create table operation it gives you the DDL information Review collected by and hosted on G2.com.

UI is not attracting and you cannot make tables in many designs. Review collected by and hosted on G2.com.

I feel SQLyog is the best application I have seen ever to manage the mysql databases.It is simple to download and install. The databases are arranged in the treeview control, by expanding the tree we can get the collection of nodes which shows the names of the tables. It is easy to use and backups are very fast. We can transfer the data from one DB to another with ease. Review collected by and hosted on G2.com.

I don't find any major problems regarding SQLyog, but for some people it seems to be confusing in some of the cases(when we talk about the freshers). And also when we try to open some tables, it crashes suddenly.

And the root connection, sometimes this creates a problem a lot. Other than these things, there are no much problems with this tool. Review collected by and hosted on G2.com.

the amount of options you get to customize your experience are great. the way that the data grids display is super simple but also very convenient and easy to visualize, which might sound obvious for a data base management tool, but it doesn't happen in all of the cases. The connections import tool works in a great and fast way. the data search feature is also very useful and adds a great value to a tool like this.

The tool gives you the option to format query, which becomes extremely helpful, especially when you need to bring code from html or xml codes Review collected by and hosted on G2.com.

UI is not the most good looking, but it keeps is simple. If you look visual customization, there are options to change the object browser color schema, which is not great, but it does allow some customization Review collected by and hosted on G2.com.

The schema sync tool. It makes the work so much easier. I also love the fact that is has SSH connection, and of course, data sync tool in that order. This tool is so much better than any other tool out there for when you need to connect to a MySQL or Aurora database. Also, I haven't had the chance to experiment with all of the features available in there. Review collected by and hosted on G2.com.

Sometimes it still crashes when trying to sync between servers. Not available on a Mac, or Linux, but that's fine since I develop on Windows. You guys need to make more tools like these. Maybe an IDE in the future? If you guys made it available on a Mac, and Notepad++ became available on the mac, I might have to move to a Mac since my whole company is on the Mac. Review collected by and hosted on G2.com.

I have been working with Sql Server since it’s first introduction. About a year ago, for various business reasons, we decided to port about 100,000 lines of Sql stored procedures to MySQl. We chose the Aurora MySQl version offered by Amazon. At first glance the SQL workbench should have provided all of the necessary functionality. But unfortunately this was not the case. So I started looking for alternatives, the recommended MySql manager did not appear to offer any advantages. Then I came across SQLyog, Hard to pronounce but definitely a better choice. I downloaded the free version to try it out and was instantly sold on the product. After about a week of trying it out we purchased the license to the product. What did it offer:

1.High reliability. The MySQL Workbench would crash for unknown reasons and was not supported on Windows Server, my development environment.

2. More functionality. As you can imagine converting a thousand of stored procedures from Sql Server to MySQL is no small task. After analyzing the code differences I was able to do a general conversion fairly quickly and then tweaking as I debugged the code with my web site code.

3. Backup functionality. Easy to make one file per object backups. This was useful to give me the ability to store my work in SVN so I can track and preserver changes over time, as well as off site backup.

4. Saving the open work files when closing and reopening the program. This is a great handy feature, one I wish Sql Server Manager had. Review collected by and hosted on G2.com.

Improvements needed: the product is great as it stands but I would like to see the following improvements.

1. When opening a stored procedure for alterations position the cursor at the top of the file instead of the bottom of the file, as I seem to always need to go back to the top to start working.

2. Add the standard Cut and paste keystroke functionality every other windows based program has namely Ctrt-X to cut the current line. As well as any other keyboard shortcuts you are missing

3. I know there were a couple of other improvements I would like to see but it slips my mind right now. Review collected by and hosted on G2.com.

UI and UX

Export / backup features

Its better than standard mysql Review collected by and hosted on G2.com.

Poor customer service and support

Disabling product downloads (even though you've paid for a lifetime product).

Constant marketing emails Review collected by and hosted on G2.com.

I love this program.I have used it for past 6 months.If we use SQLyog no need to use command promt for showing databases and records.It shows everything on the pannel.

Software stability, size, CPU and memory usage, auto complete feature for queries, data import export and visual data synchronization. Review collected by and hosted on G2.com.

we cannot download the older versions on web.This a bit of an inconvenience. Review collected by and hosted on G2.com.

Easy to use user interface, HTTP and SSL tunnelling support with SSL encryption capability, great WINE compatibility for Linux, built-in schema designer, easy to use database synchronization tool. Review collected by and hosted on G2.com.

Support for database other than MySQL, native Linux or Mac client, drag and drop support between multiple tabs. Review collected by and hosted on G2.com.

I love how I am able to quickly write and batch run multiple queries, edit data from within a search result and see the history of queries so I can reuse my work later. Before, I was using straight up MySQL to perform my queries and it was a headache. With SQLyog, I could duplicate the client's database and run my queries in a safe test environment with really quick, visually accessible results. Also, adding indexing to existing tables. So easy. Just a couple of clicks instead of lengthy queries. Review collected by and hosted on G2.com.

I suppose the only thing I could say that I disliked about SQLyog was ... that you have to be somewhat familiar with SQL to use it? But then again, why are you editing an SQL database if you don't know anything about SQL?

Having said that, the GUI is really helpful. It helps you with a bunch of niceties, like formatting your text so its easier to read and auto-completing suggestions as you type, like a traditional code editor.

So, in short, I haven't really got anything against it. :/ Review collected by and hosted on G2.com.