OK here goes. It is a VERY long set of instructions, but I hope comprehensive. As the limit is 5000 characters this is going to be in 3 parts.
For anyone else reading this, the database creation and conversion is for TP VERSION 7 ONLY. You can however still use the instructions for installing MySQL.
I am assuming you already have TP7 installed.
Install MySQL Community Server from
http://dev.mysql.com/downloads/mysql/. Scroll down and click on the big image with 'MySQL Community Server 5.6 for Windows' in it.
On the next page scroll down and choose either the web installer (1.6M) or the full download (282.4M). I recommend the full download as it is less likely to fail, although you will be downloading files you won't need for your configuration. Although they both state they are Windows (x86 32-bit), that is just the installer which isn't available in 64 bit.
On the next screen YOU DON'T NEED TO LOGIN OR SIGN UP if you don't want to. click on 'No thanks, just start my download.' Save the file to a suitable location.
When the file has downloaded double click it to start the installer. You will need to give the usual Windows permissions and then arrive at the licence agreement. Accept the terms and click 'Next'.
Click on 'Custom' and then 'Next'.
On the next screen expand the MySQL Servers category until you see the X64 version then click the right arrow to add it to the install.
Expand the Applications and then MySQL Workbench and select the x64 version.
The Notifier didn't install when I selected it and I had to install it separately, so skip this for now.
You won't need Excel, Visual Studio or Utilities unless you want to to get into advanced stuff, and in any case these can be installed later if you do find you need them.
The Connectors didn't install when I did it so we will install these later as well.
If you want the documentation or examples select those. To be honest the documentation isn't great for non-technical users; you would be better off Googling for help.
Click on 'Next'. Confirm you have MySQL Server, MySQL Workbench and Connector/ODBC all 'Ready to Install. If not click on 'Back' and double check your selections.
Finally click on 'Execute' to start the installation.
When the installation is complete click on 'Next'. You should see MySQL Server 'Ready to Configure'. Click on 'Next'.
Leave the Config Type as Development Machine. This is the best option for a general purpose set-up.
Make sure that TCP/IP is ticked and Port Number is 3306. You can untick 'Open Firewall...' if you want for added security if you are only going to connect to the database from the host machine.
Create a Root Account password. Like the Windows Administrator account you should only use 'Root' in MySQL for maintenance and configuration. You will create a user account later once the TP database has been created. Click on 'Next'.
On the Windows Service screen make sure 'Configure MySQL Server as a Windows Service' is ticked. You can leave the Service Name as suggested, or change it if you prefer.
You have a decision to make for 'Start the MySQL Server at System Startup' option. If you run other software that is system intensive, and you won't need TP at the same time, then I would suggest unticking this. You can start the service manually whenever you need it. However if you use TP every time you start up your PC then this is probably best left ticked.
Make sure that Standard System Account is selected. Click on 'Next'.
On the next screen is a checklist of the configuration steps. Click on 'Execute' to configure MySQL. When configuration has completed click on 'Finish', then 'Next', check that 'Start MySQL Workbench' is ticked then click 'Finish' again.
MySQL Workbench should open. This is the control panel for MySQL server and is where you create and maintain databases and users.
Click on the grey box that has 'Local instance MySQL56' in it. In the box that pops up enter the Root password you created earlier.
The Workbench screen may look complicated, but you don't need to worry about most of it. I will take you through the important bits.
Continued.....