I am new to Ubuntu using version 14.04 64-bit. I have successfully installed xampp and all services are running correctly. However I have installed mysql workbench and then I get the error;
Unhandled exception can't connect to mysql server on '127.0.0.1' (111) (code 2003)
I have read all over the internet that I should changed the line;
bind-number = 127.0.0.1
to have a # in-front of it to be commented out. And I have done this. I have also changed the port number from 3306 to 5123 as I am running this ubuntu on vm-ware and have xampp also installed on my windows which is using port 3306. But this did nothing. I am getting confused as what to do seeing as the mysql server says it is running on both the command line and mysql workbench but I keep getting that error when clicking on the connection in mysql workbench.
Also I get a strange reply when running the command
sudo service mysql status
sudo service mysqld status
for both of these command respectively I get the result
mysql: unrecognized service
mysqld: unrecognized service
I am not sure if this has anything to do with it.