At WNPower we are constantly working to make it easier to manage your website and apps in the cloud. That is why we created MySQL Toolbox, a very easy to use tool that will allow you to know your MySQL databases queries live, import heavy databases, configure MySQL Remote and repair issues related to indexes, and frequent problems when using stored procedures.
MySQL Toolbox is another one of our unique tools that are part of the user-friendly environment for developers to solve everyday problems in a few clicks, instead of having to think about how they can do it and spend valuable time. If you are a dev, you will love this tool.
How to access MySQL Toolbox
Just like all of WNPower’s exclusive tools, you can find MySQL Toolbox inside cPanel. Easy and straightforward.
1- Login to your cPanel control panel.
2- Go to the Exclusive Tools section, and then to MySQL Toolbox.
Quick tour of MySQL Toolbox
With MySQL Toolbox you will be able to perform some difficult or time-consuming tasks and a guaranteed headache.
View MySQL queries live
At a glance, you will be able to find out which MySQL queries and operations are running live within your hosting plan, getting a quick overview of what is going on.
Importing your MySQL databases
If you found the task of importing a database using PHPMyAdmin cumbersome, or your database is too heavy, then you’ll love this feature. Just upload your database with the File Manager, select the backup file, choose the target database, and you’re all set.
View the error log
With MySQL Toolbox you can also see the errors that are occurring within your MySQL databases, in a simple, quick and easy to analyze list if you have to solve a problem.
Configure Remote MySQL
MySQL Toolbox also allows you to configure Remote MySQL, only much more secure. Regularly other hosting companies have MySQL exposed to the Internet without any security and delegate the access control to cPanel; and in the case that they don’t, you will have to ask their support to open it or authorize it manually causing delays.
Fixing frequent “Definer” problems when editing store procedures or stored procedures
If it happened to you that when you imported your database from PHPMyAdmin or SSH console, and it brought stored procedures, you probably encountered that you can’t edit them from the web administrator. This is a frequent inconvenience that fortunately is very easy to solve with MySQL Toolbox. Select the database, press the “Reset definer” button and Magic! Fixed.
Performance reports
MySQL Toolbox also has performance reports to know how you can improve the speed and performance of your MySQL databases. Among the options, you have reports generated through the “sys” and “performace_schema” tables, and you can also check the slow queries in a top 10 so you can quickly fix them.
In which hosting plans can you find MySQL Toolbox?
As we want everyone to be able to use our exclusive tools, you will be able to find MySQL Toolbox in all our Hosting, Cloud Hosting, Reseller Hosting and Managed Servers plans.
Conclusion
MySQL Toolbox comes to simplify some cumbersome tasks to solve when you are managing your databases. It is simple to use, and it is available inside your cPanel control panel along with all the other exclusive WNPower tools.