I'm trying to use mysql workbench to get access the database in my office. My friend has already helped me setup the connection in PuTTY, so I can write my MySQL script in that "black and white" window. However when I try to use MySQL workbench to get connection to the database, it causes error. It says:
Failed to Connect to MySQL at 127.0.0.1:3306 with user martin (I tried root as well)
Can't connect to MySQL server on '127.0.0.1' (10061)
I know there are a lot of questions and answers about this on stackoverflow. I tried some of them but without any luck.
I'm thinking do I need something called mysqld.exe in a certain directory? I have downloaded the file but when I double click it nothing happens. Do I need to run that as an administrator? One of my friends told me I don't need that at all. So what should I do now?
Any clue please enlighten me. Thanks heaps!!
To connect to your MySQL database with Workbench software you should do the following:
Open your Workbench application >> Database >> Connect to database. Setup window will show up, please fill out the fields as follows:
SSH Section
Mysql Section
Just For Ilustration purposes your configuration should look something like this: