In this lesson you will read how to configured of mysql. This lesson you will also read how to easily configuring your server under window . The mysql configuring wizard create a custom my.ini file and applying your response to a template to generated the my.ini file it is tuned to your installation . The mysql configuration is included with The mysql 5.0 server and mysql also available for only window users.
Introduction of configuration wizard
The MySQL configuration wizard is typically lanched from the MySQL installation wizard so, as the MySQL installation wizard is exits. MySQL is also lanched the mysql configuration wizard through the clicking mysql server Instance configuration wizard entry of the window Start menu in the mysql session. The mysql configured to the bin directory of your installation time and lanched the mysql this file directory "mysqlInstanceConfig.exe".
The MYSQL is navigate to the bin directory of your mysql installation or launch the MySQLInstanceConfig.exe file directly.
MySQL Choosing the Maintenance Option
The mysql configuration wizard detected an exiting my.ini file ,and you have the mysql file either reconfiguration your existing server or removing the server instance through deleting the my.ini file and mysql configuration wizard stopping and removing the mysql services.
If you want to reconfigure then choose the exiting server and the Re-configure instance option then click the NEXT buttons. MySQL existing file my.ini is renamed to mytimestamp.ini.bak where are timestamp is the date and time in mysql configured wizard, mysql which is existing my.ini file created. The MySQL remove the existing server instance then choose the remove instance option and click the next button.
The mysql configured in the choose the Remove the instance option then you advance to a confirmation window, click the execute button. MySQL Configuration wizard stops and removes the mysql services, and then deletes the my.ini file. the mysql server installation and data folder are not removed.
MySQL Choosing the configuration type wizard
If when you configured new mysql configuration wizard for new mysql configuration installation then choose the re-configure instance for an existing installation. There are two type of mysql configuration wizard:-
MySQL configuration is choose the Standard option then the cause the mysql
configuration wizard set all configuration with the exception of services option
and security option. MySQL standard configuration sets options it may be incompatible with system. there are existing mysql
installations. That you have an existing mysql installation on your system in addition to the installation
then you wish to configure the detailed configuration option recommended.
MySQL server type Dialog
There are three type available MySQL Server dialog . MySQL configuration wizard is the make with regard to the memory, Disk, and processor usage. The mysql server dialog type is follow here:-