How to Configure MySQL on a Windows PC
MySQL Server configuration is managed with the MySQL Server Configuration Wizard. The wizard prompts you for information then creates a custom MySQL configuration file (my.ini or my.cnf) for your installation. The standard configuration presented here is used for new installations on a single-user development machine.
Other People Are Reading
Instructions
-
-
1
Select "Programs->MySQL->MySQL Server->MySQL Server Config Wizard" from the Start menu if you previously installed the MySQL Server software without completing configuration. Start the configuration software by selecting "Finish" in the Setup Wizard if you are continuing with configuration immediately after you installed the MySQL software.
-
2
Click "Next" in the MySQL Server Instance Configuration Wizard to start configuration. The configuration type information appears.
-
-
3
Select the "Standard Configuration" to create a general purpose configuration on your PC that you can tune later. Click "Next" to continue to the Windows options information.
-
4
Check the "Install As Windows Service" option. Use the default option for the Service Name and leave the "Launch the MySQL Server Automatically" selection checked. Click "Next" to continue to the security settings information.
-
5
Enter a root password for the root login. Re-type the password in the confirmation input field. Select the "Enable root access from remote machines" if you want to enable that feature. Click "Next" to continue to the summary and execution information.
-
6
Execute the configuration process by clicking "Execute." As the configuration is processed the configuration status appears in the window. When the configuration is complete, click "Finish" to close the Configuration Wizard.
-
1
Tips & Warnings
If you want to use the Detailed Configuration option, you need the following information: the server type (Development, Server, Dedicated Server), database type (Multi-functional, Transactional, Non-Transactional), InnoDB data file directory if not using the default, approximate number of connection (Decision Support, Online Transaction, Manual), networking and server mode options and the character set to use.
