In this tutorial I will show you how you can setup a new server instance for MySql Workbench.
MySql Workbench is a desktop application used for managing your MySql Database. Its more or less the equivalent of PhpMyAdmin and the MS Sql Server Management Studio used for managing MS Sql Database.
This is the window that you will see after opening MySql Workbench. But before you do anything with this application. Make sure that you have already installed WampServer. Also make sure that its already running in the background.
Just click on ‘create new server instance’
When you see this window, just click on ‘next’
Click on ‘store in vault’, and enter your password. If you don’t have a password for your mysql database, then leave it blank then click ‘ok’. This would store your database password so that it wouldn’t prompt you for the password every time it needs it to perform an action.
After that, click ‘next’ again.
You want to make sure everything is checked. Then click ‘next’
Just leave the configuration file blank for a while. Then click ‘next’
You’ll see an ‘x’, because we didn’t include the configuration file, but its fine for the moment since this tutorial is only for the purpose of backing up MySql Database.
It will prompt you to review the server instance settings. Just click ‘next’.
Rename the default server instance name into something that is more comprehensive. Then click ‘Finish’
That’s it, now you can perform different database operations like backup, restore, queries and others.