in Mysql-Workbench,i clicked on open connection to start querying and i get a dialog where i get the hostname,username,password,etc...
in hostname it has 127.0.0.1, user set as root, and i've enter the root password for mysql and i get this:
Cannot Connect to Database Server
Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
Lost connection to MySQL server at 'reading initial communication packet', system error: 0
Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
i've tried changing the hostname to "localhost" and i get the same result.
I've checked if mysql daemon is running, and it is.
what can i do? i really need to start my work
If anybody is having this problem this is how i fixed it:
i had to edit the file called hosts.allow in /etc, and add this line:
mysqld: all
i don't know if this is the right solution but it is working for me.
