Install and Configure MySQL 5 on Windows

Categories:

Configuring MySQL

With the installation complete you should now be presented with the MySQL Server Instance Configuration Wizard as shown below in figure 6. Click the Next button at the bottom to continue.


figure 6

When asked what configuration type you wish to use, select the Detailed Configuration option and click the Next button at the bottom as shown below in figure 7.

figure 7

The next step is choosing the server type. If you will be using MySQL on a server that is hosting other applications as well I suggest you use the Server Machine option. Once you've made your selection click the Next button to continue as shown below in figure 8.


figure 8

Selecting your database usage is an option you should give some consideration as this determines what database types are enabled. For general purpose I would recommend using the Multifunctional Database option as then both the MyISAM and InnoDB database types are enabled. Once you've made your selection click the Next button at the bottom as shown below in figure 9.


figure 9

If you selected an option in the previous step that enables the InnoDB database engine, then you will be prompted to set a path for use by the InnoDB datafile. Leave this as the default (uses the installation path) unless you require otherwise and click the Next button at the bottom as shown below in figure 10.


figure 10

Comments

Anonymous's picture

Running MySql on a server and accessing it from clients

I Have installed MySql on a powerful server running windows 2003 OS and was trying to access through clients,but its not connecting.I need information on this settings so as to what to be modified and set to run from clients
thanks
Raj

Brashquido's picture

Enable access from remote machines

Hi Raj,

To allow your client machines to connect you'll need to tick the "enable access from remote machines" checkbox as shown in figure 15.

----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Anonymous's picture

Nick

I have the same problem discribed in this response: " Nice tutorial ... but the Configuration doesn't work!"

The author of that response said something needed to be tweeked in order to get pass the problem.
Can anyone help?
thanks.

Brashquido's picture

Are you upgrading, or

Are you upgrading, or reinstalling over an existing install of MySQL?

----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Anonymous's picture

Response to " Nice tutorial ... but the Configuration ..."

Hi Guys,
MySQL noob myself, but I think I've seen the issue you are describing when I performed an install-uninstall-install with MySQL.

I believe what you are experiencing is the result of certain MySQL files not being removed completely. As a result, you are being asked for the old/current pw as well.

I was able to get things to work by using the remove utility in the mysql server instance config wizard, removing the instance and then installing mysql again.

Hope that help!

mysqlpadawan

Anonymous's picture

ReInstalling Password Problem

To ReInstall you must first use the Setup.exe and I believe it is the second GUI window and use the Remove radio button. After it says everything is removed, it is not ! You must manually delete C:\ProgramData\MySQL. I emptied my Recycle Bin, then, When ReInStalling using Setup.exe again, it does not ask for the old or current password. Make sure you write down what the new one is that you are setting. On a new command line window use C:\>mysql -u root -p and it should ask you for a password which should be the new one you just created. Hope this helps.

Anonymous's picture

MySQL ODBC Connector

Hi Dominic,

I just upgraded to the latest version of MySQL i.e. 5.1 from 4.0.26 and ran my backup SQL scripts which were imported without any issues.

I do however have version 3.51 of the ODBC Connector installed. I'm not sure why however one of the ASP (Active Server Pages) applications now no longer returns any records after the upgrade to version 5.1

Would you know why? Should I upgrade the ODBC Connector to version 5.1?

Michellea

Brashquido's picture

Checked your DSN?

I assume you have checked your DSN to ensure it is still connecting to the server OK? I'm pretty sure you can run the 3.51 and 5.1 connectors side by side, so that might be an option.

----------------
Dominic Ryan
5 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Anonymous's picture

MySQL ODBC Connector

Hi Dominic,

I have checked the DSN entries and they are connecting fine and I did attempt to run version 5.1 alongside 3.5 but Windows 2003 doesn't permit it. It returns the message that I have to uninstall the previous version.

Brashquido's picture

Look to the SQL

That is weird. I have 5.1 and 3.51 installed along side each other on my XP box, obviously not the same for 2003. When I first upgraded from MySQL 4 to MySQL 5 I can remember a lot of applications had issues working when strict mode is enabled. Not so much of an issue now I think, but it is enabled by default so might be something to check. Other things to do would be to enable the debug log in ODBC, and error log in MySQL. Also, have a look at the SQL statement(s) inside the ASP itself, and see if you can run it in an SQL window in PHPMyAdmin or similar.

----------------
Dominic Ryan
5 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster