Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Workbench wrong configuration file path

I am using MySQL Workbench 6.2.4. Whenever I install it or extract its winrar file it sets automatically a configuration path file in a Connection. But in my case it sets it automatically but it set the path of a file which never been created. I installed MySQL Workbench 6.2.4 but showing me a path "ProgramFiles\MySQL\MySQL Server 5.0\my.ini" which did not exist but I tried to create a my.ini file through "option file" option that it gives me that path not found and also in my mysql directory that is C:\Program Files\MySQL\MySQL 6.2 workbench does not contain my.ini or my.conf file. Also whenever I tried to Connect it gives me an error which is:

"Could not connect, server may not be running. (16001)"

I know this question is been asked for many times but still I could not found a solution for my problem. I also want to say that I could not find mysql server option in services.msc through which I could start my server.

connection errorcould not save configuration filemanage server connections

I hope these Screenshots are helpful.

like image 218
Asad Jivani Avatar asked Feb 02 '15 21:02

Asad Jivani


People also ask

Where is MySQL config file stored?

On RH systems, MySQL configuration file is located under /etc/my. cnf by default.


1 Answers

Edit %AppData%\MySQL\Workbench\server_instances.xml and replace

<value type="string" key="sys.config.path">%ProgramFiles%\MySQL\MySQL Server 5.0\my.ini</value>

with

<value type="string" key="sys.config.path">%ProgramData%\MySQL\MySQL Server 5.6\my.ini</value>

like image 130
Daniel Avatar answered Sep 27 '22 22:09

Daniel