I can not find my.cnf on my windows computer

mysql configuration privileges
Steven picture Steven · Nov 11, 2009 · Viewed 219.8k times · Source

My computer is Windows XP.

I need to find my.cnf to get all privileges back to the root user. I accidentally removed some privileges of the root user. I still have the password and there is no problem for me to log in to MySQL as the root user. But I can not alter a table.

Answer

fstang picture fstang · Nov 23, 2013

Here is my answer:

  1. Win+R (shortcut for 'run'), type services.msc, Enter
  2. You should find an entry like 'MySQL56', right click on it, select properties
  3. You should see something like "D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld" --defaults-file="D:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56

Full answer here: https://stackoverflow.com/a/20136523/1316649

Related questions

Determine which MySQL configuration file is being used

Is there a command to determine which configuration file MySQL 5.0 is currently using?

Read More
Changing Font in MySQL Workbench

I am using MySQL Workbench 5.2, the newest version as far as I know, but I simply cannot change the font. It is very inconvenient, because the default font is very small and harsh on the eyes. The appearance tab has …

Read More
How to get rid of STRICT SQL mode in MySQL

This is a follow up to this question MYSQL incorrect DATETIME format How to get rid of STRICT_TRANS_TABLES once and for all? mysql --help reports the following configs: Default options are read from the following files in the …

Read More