When comparing SQLyog vs XAMPP, the Slant community recommends XAMPP for most people. In the question“What are the best MySQL client applications for Windows?” XAMPP is ranked 6th while SQLyog is ranked 7th. The most important reason people chose XAMPP is:
Port 443 is in use from Skype. You can change the port in Skype.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Easy to use and elegant UI
The UI is uncluttered and intuitive.
Pro Visual design of queries
Query builder is very intuitive and easy for designing very complex queries.
Pro Community version
There is a free/community version available here.
Pro Power tools
There are very useful power tools to do task like database synchronization, visual data comparison, Schedule backup with email notification. One can also schedule task with scheduler and will get report of task completion or error in email.
Pro Session restore
User can enable session restore to avoid loss of unsaved work.
Pro Data visualization
Pro Store model in project file
Pro Discounts for multiple users
Pro Free upgrades for 1 year included
Pro Unconditional 90-day money back policy
Pro Premium support option
Pro Personalized themes
Pro Fast and stable
Completely written in c/c++ using win32 api gives is edge in performance over other clients.
Pro Advanced connection options
It's possible to connect to any MySQL server with these powerful connection options - HTTP, SSH, SSL.
Pro Smooth installation with minimal configuration required
Port 443 is in use from Skype. You can change the port in Skype.
Pro Multi-platform
XAMPP runs on OS X, Linux and Windows.
Pro Clean and functional interface
Cons
Con Premium support at an additional cost
Con Cost
Pricing starts at $69 and goes up to $299.
Con Bloated
Comes with mail server, FTP server, accelerator, web-dav, ssl out of the box, etc.
Con doesnt has phpselector
Need downgrade to use php5
