Search code examples
mysqlmysql-workbench

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 error could not save configuration file manage server connections

I hope these Screenshots are helpful.


Solution

  • 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>