Geeks With Blogs

Stuart Brierley Integration Management - BizTalk and More

Having previously detailed how to install MySQL Server, the next step is configuring MySQL. The MySQL configuration wizard can either be run immediately following installation from the MySQL installation wizard or manually from the Start Menu.

MySQL Configuration - Splash Screen

Following the splash screen you can then choose whether to run a detailed or standard configuration. The detailed configuration allows you to create the optimal configuration for your specific machine, whereas the standard configuration creates a general configuration that can then be manually tuned. I chose detailed.

MySQL Configuration - Options 

You are then asked to choose the type of server instance that is being configured. In this case it is a developer machine.

MySQL Configuration - Instance

Following this you are asked to choose the type of database usage that you expect on the server. I opted for multifunctional.

MySQL Configuration - Instance 2

You must then specify the location of the InnoDB tablespace.

MySQL Configuration - InnoDB 

Next specify the number of concurent connections to the server.

MySQL Configuration - Connections 

Now you must configure the networking options. I left the Strict mode enabled as this is the recommended option, but I disabled TCP/IP networking as I wanted to restrict this MySQL installation to the local machine only.

MySQL Configuration - Networking 

Set the character set that is best suited to your use - for me this was the default standard character set.

MySQL Configuration - Character Set

Next up is the option to run MySQL as a service and whether or not to include the mysql dircetories in the windows PATH. I kept the install as a windows service option enabled, but unchecked the Launch MySQL server automatically option. This is because I only wanted MySQL running when I specifically want to use it. I also enabled the include in windows PATH option.

MySQL Configuration - Windows Options 

You can then change the security settings for the mysql installation. I opted to change the root password, disable root from local machines and disable annoymous access.  

MySQL Configuration - Security

You are now ready to execute the configuration.

MySQL Configuration - Execute 

Once completed you should hopefully see the completed screen with lots of nice ticks against the various configuration tasks.

MySQL Configuration - Finished

Posted on Monday, June 7, 2010 10:20 AM Random Thoughts of Interest | Back to top

Comments on this post: MySQL - Configuration

# re: MySQL - Configuration
Requesting Gravatar...
Hi All,

I have installed mysql 5.5 version onto system but have installed the Detailed Configuration instead of Standard Configuration.

As am a beginner for mysql please suggest me how could i change the configuration from Detailed to Standard also please explain if there could be any issues by using the Detailed edition instead of Standard edition.

Because while installing Detailed didnot ask for any username it was asking for a password instead( root password) however found out that "root" was the user name for the database.
Left by Lokesh on Aug 20, 2011 8:11 AM

Your comment:
 (will show your gravatar)

Copyright © Stuart Brierley | Powered by: