Thursday, 9 April 2015

Configuring MYSQL Server

Configuration of Mysql server begins with defining following types of networking options.

Mysql server configuration panel
Server Installer Overview
 Server configuration Types : it defines amount of system resources that will be assign to your Mysql server instance.
  • Developer : It is basically your personal workstation.It configure Mysql to use least amount of system memory.  
  • Server : It consumes medium amount of system memory.
  • Dedicated : It is a machine that is dedicated to running Mysql server because no other major application are running on this server such as web servers.This consumes most amount of system memory.
Connectivity : this option define how you will connect to Mysql.
  •  TCP/IP : This is the most eligible option for server because this will connect you with port otherwise only localhost connections will allowed.
  • Named pipe : Enable and define the pipe name, similar to using --enable named-pipe option.
  • Shared memory : enable and then define the memory name, similar to using --shared-memory option.
Advanced Configuration : This option provides additional logging option configuration.
Accounts and Roles : This is the next option under installation.In this option You must provide root password for your server logging.
if Mysql server is already installed then you should provide current root password 
Windows Service :
  • Now you configure the Windows Service details. This includes the service name, whether the MySQL Server should be loaded at startup, and how the Windows Service for MySQL Server is executed. 
Advanced Option :
The next configuration step is available if the Advanced Configuration option was checked. This section includes options that are related to the MySQL log files. Now click apply server configuration and then click execute.This is all about server configuration.
For starting server enter the following command on cmd :
C:\> "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld".

No comments:

Post a Comment