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.
I hope these Screenshots are helpful.
On RH systems, MySQL configuration file is located under /etc/my. cnf by default.
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>
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With