My cnf file in MySQL Windows

You must create and configure the my.cnf file for configuring MySQL database on the Windows machines.

Procedure

To create and configure the my.cnf file for Windows machines, complete the following tasks:

1. Create the my.cnf file in a text editor, and save it to the following location: D:\Spend\mysql-5.5.15-winx64.

   In this guide, we’ll show you how to make changes to your database settings in the MySQL my.cnf file. For example, you may need to increase the number of max_connections or the query_cache_size value for your server.

   To do this, you simply log in the server via SSH and edit the my.cnf file using an editor such as Nano. This article will explain the steps to view and edit your my.cnf file. We’ll also show you how to view your MySQL variables through SSH then how to access them in phpMyAdmin, where they can be edited.

   You will need root access to our VPS or Dedicated server to follow this guide.

   Get better performance and security with our NVMe VPS Hosting plans.

   Don’t have time to read the article. Watch our video tutorial here.

   How to View Mysql Settings in the my.cnf File

   1. Login to your server via SSH
   2. To view the MySQL my.cnf settings type the following:
      

      cat /etc/my.cnf

      
      
      
      
      The contents of the my.cnf file will display similar to the snapshot above.

   Editing the Mysql my.cnf File

   1. Login to your server via SSH.
   2. To edit the MySQL settings with nano type the following:
      

      nano /etc/my.cnf

      
      

      There are several editors you can use in shell. Nano, Vim, or Emacs. This article will focus only on Nano.

      
      
      
   3. Find the line to edit. For example, if you want to edit the max_connections, find the following line.
      max_connections=100
      
      
   4. To increase the max_connections to 110 change it to the following.
      max_connections=110
   5. Enter Ctrl + O to “WriteOut” or save the settings.
   6. Then Ctrl + X to exit.
   7. Restart MySQL by typing the following.
      

      service mysql restart

      
      Now the max_connections is increased to 110 instead of 100.

   Viewing the Mysql Variables Through Shell

   1. Login to your server via SSH.
   2. Type the following command.
      

      mysqladmin variables

      
      
      
      
      The variables will display similar to the snapshot above.

   Viewing MySQL Variables in phpMyAdmin

   1. Log into your phpMyAdmin.
   2. Click the Variables tab at the top right. Then PhpMyAdmin will list all the variables and their settings on your server.
      
      
   3. If you want to edit the values, you should edit the my.cnf file as described above.

   Now you know how to edit your database settings in the MySQL my.cnf file and view database variables. For more guides check out our full section on Working with Databases.

   MySQL starts up with configurations defined in a file named “my.ini”.  To find where the active “my.ini” configuration file is located on the Windows Server:

   Step 1) Open Windows Services (e.g. start –> run –> “services.msc”)

   Step 2) Find the appropriate MySQL Service entry (e.g. “MySQL” or “MySQL56”), in this example it’s “MySQL80-3307”

   

   Step 3) Right click and select Properties

   Under the text “Path to executable”, the path to the “my.ini” file shown next to the parameter “–defaults-file”

   In this example, the location of the my.ini file is:

   C:\ProgramData\MySQL\MySQL Server 8.0\my.ini

   

   On Linux

   MySQL starts up with configurations defined in a file named “my.cnf”.  

   To find where the active “my.cnf” configuration file is located on the Linux Server:

   Step 1) From a Terminal/Shell/Command Line, execute the command: mysql –verbose –help

   The command will yield a long list of text as the result.  

   Step 2) Scroll to below the “Usage: mysql [OPTIONS] [database] section” and below the line that reads: “Default options are read from the following files in the given order:“, there will be an ordered list of possible filesystem locations for the my.cnf file.  In this example, there are 4 locations will which MySQL will look for.  

   /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

   To made configuration changes, modify the first available file (from left to right), in this example this would be “/etc/my.cnf”

   Updated on March 30, 2020

   Was this article helpful?

   About The Author

   Variphy

   Our mission, since 2004, has been to help simplify the use and management of Unified Communications and Collaboration products through quality software and service delivery.

   Where is my CNF file in MySQL in Windows?

   C:\Program Files\MySQL\MySQL Server 5.5\my. ini C:\Program Files\MySQL\MySQL Server 5.5\my. cnf.

   How do I edit a CNF file in MySQL windows?

   Editing the Mysql my..

   Login to your server via SSH..

   To edit the MySQL settings with nano type the following: ... .

   Find the line to edit. ... .

   To increase the max_connections to 110 change it to the following. ... .

   Enter Ctrl + O to “WriteOut” or save the settings..

   Then Ctrl + X to exit..

   Restart MySQL by typing the following..

   Which CNF file is MySQL using?

   The primary configuration file for the MySQL database server is called my. cnf.

   Where is the my ini file located?

   The my. ini is in hidden folder of program data. First go to C: drive and then hidden folder of program data.