MySQL Workbench export problem - "mysqldump.exe is version 5.5.16" will not work with version 5.6.10 of MySQL Server"

Got this error today when trying to export a database hosted on MySQL Server 5.6.10 using MySQL Workbench 5.2.47.

Opening up a command-prompt and comparing the mysqldump.exe versions between MySQL Server and MySQL Workbench showed following

Solution
Copied the mysqldump.exe (version 5.6.10) from the MySQL Server 5.6 installation folder and replaced the mysqldump.exe (version 5.5.16) at the MySQL Workbench 5.2 CE folder.

Export now works like a charm again.

Changing MySQL root password

1. Launch a command-prompt. 
2. Navigate to the bin folder of your MySQL installation.
   (e.g. C:\Program Files\MySQL\MySQL Server 5.6\bin)
3. Start the MySQL command-line interface via
   mysql -u root -p 
4. You will be prompted to type your existing root password.
5. After a successful login you should see a prompt saying 'mysql>'. 
6. Enter following command to change password
   SET PASSWORD FOR root@localhost=PASSWORD('new_passw_goes_here');
7. Volia!

What time and timezone does a MySQL instance use?

select CURRENT_TIMESTAMP();
select @@global.time_zone;

Complete uninstall/removal of MySQL

Simply uninstalling MySQL using the Windows standard Programs and Features->Uninstall is not enough if you want to completely remove MySQL from the machine.

Here are the steps required:

• Uninstall MySQL using the standard Windows program uninstaller
• Delete C:\Program Files\MySQL
• Delete C:\Program Files (x86)\MySQL
• Delete C:\ProgramData\MySQL
• Delete from any Users' AppData folders. Example: C:\Users\rdoverby\AppData\Roaming\MySQL
• Reinstall MySQL