Administrate MySQL Databases With Ease Using a Graphical Interface
MySQL is probably the world's most popular open source database engine but it can be difficult to administrate using its text-based tools and configuration files. SQLyog provides a full graphical interface to make using MySQL's powerful features simple even for beginners.
Design Edit Administrate and Query MySQL Databases
SQLyog's intuitive graphical user interface makes managing all aspects of your MySQL databases easy. Simple operations can be accomplished using the many pre-defined tools and functions while more complicated tasks can be built using the graphical editor which helpfully generates queries in correct SQL syntax to perform and learn from. SQLyog is able to handle databases of all sizes and can use SSH an HTTP tunnelling to make remote access simple and secure. Data transfer from external ODBC-compliant databases is also easy using the in-built import tool.
Opening Up MySQL's Power to Everyone
There's no doubt that the MySQL engine is highly powerful and flexible but managing its features through the standard text interface is daunting for beginners and a little clunky for even experienced users. SQLyog removes this barrier by making even its deepest functions available through a friendly and accessible interface. The one major downside is the complicated pricing structure offering several editions of differing power and functionality charged on a per-user licence.
Changes
Bug fixes
Cathy Buggs
I was born and raised in Bulawayo, Zimbabwe. I started working in a branch of the military before moving into the computer industry in 1979. We moved to Cape Town in 1983 where I worked for a import/export company. I then joined De Beers, where I worked for the next 20 years, rising to become the IT Manager at one of the De Beers mines. I retired in 2007 and since then I have enjoyed a third career as a freelance writer, editor and freelance tutor to disadvantaged students mainly over the internet. I have always had a deep love for English and the written word and have relished writing and expanding my skill set. I love reading and also dabble in many arts and crafts. My husband and I love camping, travelling and using our 4X4 to spend as much time as possible in the wild areas of Southern Africa.
Pros
Wide range of predefined tools and queries
User-friendly visual interface
Query results editing interface familiar to anyone who's used Excel
Cons
Per-user licencing model can get complicated and costly
SQLyog is an easy-to-use, compact and very fast graphical tool to manage your MySQL database anywhere in the world. There are a number of features designed to help you speed up your database development.
Top tools include:
Shortcuts to quickly generate SQL statements and paste object names
Learn MySQL by looking at the SQL generated by SQLyog
Multi-tab query editor and result-set editor
Multiple Query Execution
Multi-threaded query execution with option to stop long running queries
SQL templates
Excel-style grid interface to view/update resultsets
very good ti helpull developer when they build aplication to finish their project
by Anonymous
Excelent . It's really good for managing your database especially when it comes to a huge database. :)Jehreykein
by Anonymous
SQLyog is easy-to-use. The Best of all MySQL GUI! I was evaluating this software from past 3 years, now I am thinking of buying 3 Unlimited Pack for my own firm. Keep up the good work guys!
Laws concerning the use of this software vary from country to country. We do not encourage or condone the use of this program if it is in violation of these laws. Softonic may receive a referral fee if you click or buy any of the products featured here.
