Where can I find the file my.ini file for windows mysql server?

mysql replication my.cnf
gaurav picture gaurav · Dec 6, 2011 · Viewed 51.6k times · Source

The same question is repeated again and again and i am another one repeating this question . I have already set up my mysql server . Its location is C:\Program Files\MySQL\MySQL Server 5.5 but i am not able to find the my.ini file inside the above path . When i type the command c:>mysql --help The output looks like

Default options are read from the following files in the given order: C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf C:\Program Files\MySQL\M ySQL Server 5.5\my.ini C:\Program Files\MySQL\MySQL Server 5.5\my.cnf The following groups are read: mysql client

But when I opened the above locations from where it is reading these files ,I am unable to locate the file . Can anyone tell me what is the exact way to retireve the my.ini file for WINDOWS?

Answer

Iván Quiñones picture Iván Quiñones · Jan 19, 2013

In MySQL 5.5 Windows the default path for my.ini is C:\ProgramData\MySQL\MySQL Server 5.5

You may need to change your file browser (windows explorer) options to show hidden files and directories.

Related questions

MySQL slave I/O thread not running

I have set up replication for MySQL server. I can connect from the slave machine to the master server using the replication user/password. I have got the slave SQL thread running, but the slave I/O thread is not …

Read More
Error: "could not initailize master info structure" while doing Master Slave Replication in MySQL

I am trying to do Master Slave Replication for MySQL. When i am typing the following command: CHANGE MASTER TO MASTER_HOST='10.1.100.1', MASTER_USER='slave_user', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=451228; …

Read More
Updating AUTO_INCREMENT value of all tables in a MySQL database

It is possbile set/reset the AUTO_INCREMENT value of a MySQL table via ALTER TABLE some_table AUTO_INCREMENT = 1000 However I need to set the AUTO_INCREMENTupon its existing value (to fix M-M replication), something like: ALTER TABLE some_…

Read More