CODEWITHSUNDEEP
mysqlmysql-workbench
Asad Jivani
Asad Jivani

Reputation: 553

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.

Upvotes: 14

Views: 31301

Answers (3)

Dsido
Dsido

Reputation: 1

Press Win+R, type services.msc, and press Enter. Search for the Mysql80 service and start it if it exists, otherwise install it.

Upvotes: -3

user2708952
user2708952

Reputation: 3

Upgrading to MySQL Server 8.0 from several prior versions resulted in old values remaining unchanged in the following parameters in %AppData%\Roaming\MySQL\Workbench\server_instances.xml (the file Daniel mentioned in his '15 post):

<value type="string" key="sys.mysqld.service_name">MySQL57</value>

<value type="string" key="name">Local MySQL57</value>

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

A more difficult to find parameter also remained unchanged. Several lines below the line beginning with this text: <value type="object" struct-name="db.mgmt.ServerInstance", this parameter was left unchanged:
<value type="string" key="name">Pearl</value>

Changing these values corrected the display in the "Server Status/Administration - Server Status" panel where the filename displayed after "Configuration File" had been incorrect.

Upvotes: 0

Daniel
Daniel

Reputation: 3501

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>

Upvotes: 31

Related Questions