Error: cannot find the c:\wamp64\bin\mysql5.7.19\my.ini file

Question

I'm using MySQL version 5.7.19 64bit version in my windows machine and I'm trying to change my default port number 3306.

But when I open my.ini file following error appears,

cannot find the c:\wamp64\bin\mysql5.7.19\my.ini file

When I click the yes button blank notepad file will be created. In this situation what Is my solution?

PS: I referred Can't find my.ini (mysql 5.7) question but still not able to find a proper answer for this situation

Please can you tell me how to access MySQL in cmd because I'm a newbie — INDRAJITH EKANAYAKE, Apr 11 '19 at 07:49
You can open a command prompt in your pc and type in `mysqld --help`. if it works, then you will see some output like `Default options are read from the following files in the given order:`, and it will list the config file it uses. Open the file shown there and edit. — Nimeshka Srimal, Apr 11 '19 at 08:17
'mysqld' is not recognized as an internal or external command, — INDRAJITH EKANAYAKE, Apr 11 '19 at 08:55
how did you try to open my.ini file? via wamp control panel? — Unknown, Apr 11 '19 at 11:05

score 6 · Accepted Answer · answered Apr 12 '19 at 05:30

6

No, the configuration file cannot be blank. I think there's a problem with your wamp setup. However, if you want to edit the mysql conf file, you can see which file is loaded and edit it.

Open a command prompt and change your location to:

C:\wamp64\bin\mysql\mysql5.7.19\bin

Then run the command: mysql --help. You will see an output similar to below image. Just open that file and edit.

Hope it helps!!

answered Apr 12 '19 at 05:30

Nimeshka Srimal

8,012
5
42
57

Yes, you will get a long list..Look for the lines I have highlighted in the above image. In the second red box above, you can see some file paths are shown? Those are the loaded configuration files. Notice the last path shown there, and edit it manually. – Nimeshka Srimal Apr 12 '19 at 17:00

Error: cannot find the c:\wamp64\bin\mysql5.7.19\my.ini file

1 Answers1