Posted By: Anonymous
I have already seen
But I am still stuck with the ages old question!
“Where is my my.ini”
I am using windows server 2008 with mysql 5.5.28. I installed the service using mysqld –install and I am able to use the mysql server using sqlyog. But unfortunately I am not able to find my.ini in
installation directory or not in
c: neither in
c:windows nor in
show variables like "mysql_home" returned nothing as well.
You have to look I the folder
C:Program FilesMySQLMySQL Server 5.5 but there is a problem. When you perform an MSI install of MySQL, my.ini is not created. There will be sample .ini files in that folder. In order to use one of them, say
my-medium.ini, you need to do the following before a MySQL restart:
cd C:Program FilesMySQLMySQL Server 5.5 copy my-medium.ini my.ini net stop mysql net start mysql
Once, you do this,
my.ini can be read by
C:Program FilesMySQLMySQL Server 5.5binmysql.exe.