Configuration : Windows
The default configuration of MySQL on Windows can be done very easy with the wizard. You can call it any time in the start menu with the link MySQL Server Instance Configuration Wizard once again.
Configuration Wizard
Welcome window which shows the MySQL Version to configure.
Configuration Type
Choose the option Detailed Configuration here.
Server Type
The server type is selected depending to the use of the machine. These settings limit the ensured memory for MySQL for smooth operation together with other programs.
Database Usage
The most important engine is InnoDB because it supports transactions so just choose it as the main storage engine like in the image beside.
InnoDB Tablespace Settings
Just use default settings here.
Concurrent Connections
The first option Decision Support is enough for now. It allows maximal 100 connections and expect an avarage of 20.
Network Options And SQL Mode
Installation on the developer machine the default port 3306 can remain. You should activate SQL Strict Mode for the use of transaction.
Default Character Set
For international applicaiton UTF-8 is needed, so choose Best Support for Multilingualism here.
Windows Options
The selection shown by the image installs MySQL as service which is executed automatically on windows start. The inclusion into the windows path allows the call of the MySQL client program from every directory.
Security Options
In this window you just set an arbitrary password.
Execute
Starts the configuration of MySQL.
Error Number 1045
In some case the follow error occur:
The security settings could not be applied.
Error Number 1045.
Access denied for user 'root'@'localhost'
(using password: YES)That means MySQL could not change the password. The configuration has been executed nevertheless!
You do not have to a specify a password when you login to the server.
Resources
- [1] MySQL 5.1
Author: Johannes HammoudComments Date: 07.11.2009
