- Introduction:
- Prerequisites:
- My Development Environment:
- The MySQL Tools:
- Homework:
- Setup Wizard Options chosen for the Admin GUI tools:
- Here we go:
- Change Location:
- Setup Type:
- Custom Setup:
- Current Settings:
- Wizard Completed:
- Administration GUI Toolkit Install Verification:
- Windows Desktop Setup:
- Open Admin GUI:
- Open Query Browser:
- Setup Wizard Options chosen for the Workbench (OSS Version) tool:
- Here we go:
- Setup Type:
- Custom Setup:
- Current Settings:
- Wizard Competed:
- Workbench Tool Install Verification:
- Windows Desktop Setup:
- Open Workbench:
- Next Step:
Introduction:
TechNote 4 in the WordPress installation and setup series reviews the procedures for setting up 5.x of MySQL Administrator and Workbench, and also touches on the MySQL Migration Toolkit.
Prerequisites:
See TechNote: 0-WordPress Install Sequence On XP Pro plus Reference Links
My Development Environment:
See TechNote: 0-WordPress Install Sequence On XP Pro plus Reference Links
The MySQL Tools:
MySQL Administrator: All of the items that you can do with MySQL‘s GUI Administration can pretty much be done via command line options, or phpMyAdmin, and so forth. However. I find that the Administrator application is more user friendly and it saves on a lot of typographical, and other such swearing under the breath, errors. I’m interested in developing my web site, not in being a “hard core” database administrator.
MySQL Workbench: This is a tool to build and update your databases via a graphical interface. The OSS version (the free download version) will let you do that, sort of. The downside to the OOS version is that it won’t connect directly to your Server and Database – you must do so via script imports and exports. This is a pain if you are trying to re-engineer an existing database, or create one from scratch.
I’ve downloaded OSS to play with it, and included its install steps here so you can do the same. However, I fully intend to get the Commercial SE version for something like $100 per year. From what I’ve seen of the tool already this is well worth it, and one heck of a lot cheaper than DB Artisan (which is a killer tool but terribly expensive for the in-my-garage developer).
With that said, neither version of MySQL Workbench is necessary to get WordPress up and running on your XP Pro box. For that, you only need MySQL Administrator (or phpMyAdmin if you prefer).
MySQL Migration Toolkit: There is a third download and installation that you can do: the MySQL Migration Toolkit (MT). To install it, you need to have Java Runtime Environment (JRE), version 5.0 Update 8 – later versions have been creating problems. This version of the JRE is available on the Sun site as an archived version, for it is no longer supported.
However, unless you are planning on migrating database schema from other databases there is no need to install MT. As database migrations are not in my task-forecast I’m not going to be installing it either and so will not document the install here. Note: besides that, there is a note on the MySQL Forums that suggest Workbench 5.2 will include MT functions.
Homework:
Before beginning the installation I suggest you study each of the Reference Manuals for these tools (see list below). There are a number of key questions you need to investigate and answer before beginning:
- Determine if the GUI tools will run on your platform – most are acceptable but verify yours on the download sections of the MySQL site:
- Admin tools: http://dev.mysql.com/downloads/gui-tools/5.0.html
- Workbench OSS: http://dev.mysql.com/downloads/workbench/5.1.html
- Choose which version:
- Though you need to check for upgrades and patches, regularly, as of this writing there is only one version for each of the tools, all of which support MySQL 5.1:
- MySQL Administrator 1.2
- MySQL Query Browser 1.2
- MySQL Migration Toolkit 1.1 – only IF you are migrating schema from other databases
- Workbench 5.0 OSS – the free version
- The current Windows version of the downloads for these tools is:
- Admin tools: mysql-gui-tools-5.0-r17-win32.msi
- Workbench: mysql-workbench-oss-5.0.30-win32.msi
- Though you need to check for upgrades and patches, regularly, as of this writing there is only one version for each of the tools, all of which support MySQL 5.1:
- Choose a distribution format:
- Binary – this is far easier to install and unless you have an overwhelming urge to dig into source code I would stick with it.
- Source Distribution – this is the “guru level” version and unless you have a lot of time on your hands I wouldn’t recommend it.
- Download the Reference Manuals from the MySQL web-site:
- Admin GUI: administrator-en.pdf
- Query Browser: query-browser-en.pdf
- Migration Toolkit: migration-toolket-en.pdf
- Workbench: workbench-en.pdf
Setup Wizard Options chosen for the Admin GUI tools:
Here’s where I started – note: I do not load anything into my C: drive that I do not have to. In my mind, that is for O/S level installs. As I have multiple drives, everything else goes elsewhere.
MySQL Tools Install Start Display - Click on image to enlarge
Here we go:
MySQL Tools Wizard Display - Click on image to enlarge
MySQL Tools License Agreement - Click on image to enlarge
Change Location:
MySQL Tools Change Locaton Option - Click on image to enlarge
As I’ve noted in other docs in this series, I never put anything onto the C: drive that I don’t have to. Nor, did I put it under my project directory (..\FromTheRanks) because these tools, as with the database server, can and will be used for other projects.
Setup Type:
MySQL Tools Setup Type Options - Click on image to enlarge
I’ve selected Custom because I do NOT want to install the Migration Toolkit (see Installation Notes above).
Custom Setup:
MySQL Tools Custom Setup Options - Click on image to enlarge
I’ve disabled the install of the MySQL Migration Toolkit. And I’ve visually verified that my install location is correct.
Current Settings:
MySQL Tools Current Settings Display - Click on image to enlarge
Wizard Completed:
MySQL Tools Wizard Completion Display - Click on image to enlarge
No errors were reported so I should be good to go.
Administration GUI Toolkit Install Verification:
To verify the install is complete I recommend the following steps:
Windows Desktop Setup:
To verify that Windows desktop was setup properly, do the following:
Start –> Programs –> MySQL …
You should see something like the following:
Windows MySQL Tools Program List-1 - Click on image to enlarge
Open Admin GUI:
Select MySQL Administrator from the Programs list, as above.
Note: before trying to connect, be sure to start up the MySQL service!
MySQL Admin Connection Popup - Click on image to enlarge
If the service is up and running properly (you should have tested this during the Install of your MySQL server) and if you’ve started up the service (like I forgot to do, because I have it set up to be a Manual startup Service) you will end up at a GUI window that looks something like this:
MySQL Admin Server Info Window - Click on image to enlarge
If you do, you are good to go. See the training/user manuals for MySQL Administrator for further data on using this tool.
Open Query Browser:
Start –> Programs –> MySQL –> …
Windows MySQL Tools Program List-1 - Click on image to enlarge
Select MySQL Query Browser from the Programs list, as above.
When you do, you should see the following pop-up. This login window has the same connect data as with the GUI Administrator, with one exception. It is asking for a Default Schema.
MySQL Query Browser Connection Popup - Click on image to enlarge
If you do not enter one (and you don’t absolutely have to), you will get the following Dialog window:
MySQL Connection Dialog-No Default Schema Specified - Click on image to enlarge
Typically you would want to connect to your primary database. As we don’t have one yet, you can connect to the “mysql” database – a default database built as part of the install. Or, you could use “test”, which is empty.
Once you’ve entered all of the correct, and valid, information you will see a window that looks something like this:
MySQL Query Browser Display - Click on image to enlarge
If you do, you are good to go. See the training/user manuals for MySQL Query Browser for further data on using this tool.
Setup Wizard Options chosen for the Workbench (OSS Version) tool:
Here’s where I started – note: I do not load anything into my C: drive that I do not have to. In my mind, that is for O/S level installs. As I have multiple drives, everything else goes elsewhere.
NB: for this tool to work you need to have .Net Framework 2.0 in place. If you don’t (though odds are fairly good you do if you’ve been keeping up with your MS updates), you can download the Redistributable Package from Microsoft:
To verify whether you have it, or not:
Start –> Settings –> Control Panel –> Add/Remove Programs
Look for: “Microsoft .Net Framework 2.0 Service Pack 2″. V3.0 is okay but you still need V2.0.
Once .NET 2.0 is verified, select and double-click on the Workbench Installer, where ever you’ve downloaded it to, to begin:
MySQL WorkBench Installation Start - Click on image to enlarge
Here we go:
MySQL WorkBench Wizard Display - Click on image to enlarge
Setup Type:
MySQL WorkBench Setup Type Options - Click on image to enlarge
I am going to be installing everything, however not in the default location, so I selected “Custom”.
Custom Setup:
MySQL WorkBench Custom Setup Options - Click on image to enlarge
Current Settings:
MySQL WorkBench Current Settings Display - Click on image to enlarge
Verify that all is correct, then click “Install”.
Wizard Competed:
MySQL WorkBench Wizard Completion Display
Again, no errors reported so I should be good to go here too.
Workbench Tool Install Verification:
To verify the install is complete I recommend the following steps:
Windows Desktop Setup:
To verify that Windows desktop was setup properly, do the following:
Start –> Programs –> MySQL …
You should see something like the following:
Windows MySQL Tools Program List-3 - Click on image to enlarge
Open Workbench:
Select MySQL Workbench from the Programs list, as above. It took a minute but eventually a splash screen that looks like this came up:
MySQL WorkBench Splash Screen - Click on image to enlarge
Then came the Workbench. Yours should look something like this:
MySQL WorkBench Work Window - Click on image to enlarge
To be repetitive: If you do, you are good to go. See the training/user manuals for MySQL Workbench for further data on using this tool.
In a later document on setting up WordPress, I’ll go over the essential actions you need to do with MySQL Admin.
As noted earlier, I installed Workbench merely to “play” with it before buying the SE version, which allows forward and reverse engineering via direct connections to your server and database.
Next Step:
The next step is to set up PHP, a scripting language used to build WordPress and templates you may well use with WordPress. See: TechNote: 5a-WordPress Install – PHP 5-2-x Install-Setup.
DP Harshman
