MediaWiki Installation on Windows Server 2003 (WAMP) – Part 2 – MySql

After installing Apache, the next step is to install MySql (or I’m making that the next step!).

This is really sadly the hardest part (at least when using the Windows Installer) and I came across some annoying little problems.

I’ve included troubleshooting sections after the installation. If you have the service stop or an error dialog while trying to configur the server then refer to those sections.

Articles in the Series

Installing MySql

To install MySql I do the following:

  1. Download the latest version of MySql from here
  2. Run the Executable (Version used in this document is “mysql-5.1.35-win32.msi”)
  3. Click “Run” when security warning dialog comes up
  4. When installer wizard is ready click “Next >”
  5. Ensure “Typical” is selection and click “Next >”
  6. Accept the locations and click “Install”
  7. Click “Next >” a few times when the advertising dialog comes up!
  8. Un-check the “Register the MySql Server now” option and click “Finish”. The installation dialog will close and the configuration dialog will open
  9. Click “Next >”
  10. Select “Standard Configuration” and click “Next >” Please note that you MAY cause issues by using anything but “Standard Configuration” on some systems. So always choose it!
  11. Ensure “Install As Windows Service” is selected and the service name is “MySql”. The “Launch the MySQL Server automatically” option should also be checked.
  12. Click “Next >”
  13. Enter the password in each of the password boxes and click “Next >”
  14. Click “Execute”
  15. Click “Finish”

We are now (Hopefully!) done installing MySql… Issues??? Read on!

Troubleshooting

So you have probems? Here are the ones that I’ve come across and their solutions.

During Configuration the Service Doesn’t Start!

It think this is essentially because the service is already started though I’m not sure. To get around this I do the following

  1. Close the dialog
  2. Run the “MySQL Server Instance Config Wizard” which is located in the start menu
  3. Select the “Reconfigure Instance” option and click “Next >”
  4. Select “Standard Configuration” and click “Next >” Please note that you MAY cause issues by using anything but “Standard Configuration” on some systems. So always choose it!
  5. Click “Next >”
  6. Enter passwords again
  7. Click “Next >”
  8. Click “Execute”. You should now get to the Apply Security settings option
  9. Click “Finish”

Connection Error: Nr. 1045 Access denied for user ‘root’@’localhost’ (using password: No|Yes)

Don’t have a clue why this happens, but this process seems to solve it!

1. Open the my.ini file while the error dialog is still up! File is located in the following directory “C:\Program Files\MySQL\MySQL Server 5.1”

2. Add the following to the bottom of the [mysqld] section of the file (Found this information here originally.) Please note that you will want to configure your firewall to let MySql through!!!

max_allowed_packet = 1M
skip-grant-tables
# table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M

3. Open a command prompt and type

net stop mysql

4. Then type

net start mysql

5. On the configuration tool error dialog click “Retry” and it should pass and complete successfully.

Reinstalling MySql

Just some notes about reinstallation of MySql. If you run the installer and remove MySql then make sure you remove the data directory.

Usually I remove the following two directories (if using the default paths given in installation)

  • C:\Program Files\MySql\MySQL Server 5.1\
  • C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\

I do this before reinstalling or after removing. I’m not sure yet as to whether there might be some registry settings or other things stored in other places that should be removed!

Next one is PHP!

Advertisements

4 Responses to “MediaWiki Installation on Windows Server 2003 (WAMP) – Part 2 – MySql”

  1. MediaWiki Installation on Windows Server 2003 (WAMP) – Part 1 – Apache « What to call it? Says:

    […] MediaWiki Installation on Windows Server 2003 (WAMP) – Part 2 – MySql […]

  2. MediaWiki Installation on Windows Server 2003 (WAMP) – Part 3 – PHP 5 « What to call it? Says:

    […] MediaWiki Installation on Windows Server 2003 (WAMP) – Part 2 – MySql […]

  3. MediaWiki Installation on Windows Server 2003 (WAMP) – Part 4 – MediaWiki « What to call it? Says:

    […] MediaWiki Installation on Windows Server 2003 (WAMP) – Part 2 – MySql […]

  4. Installing SugarCRM « What to call it? Says:

    […] already installed Apache 2.2, MySql 5.1, and PHP 5 and therefore I’m ready to install […]


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: