You are not logged in.
when i installed mysql i got this message:
WARNING: The host 'ArchStigma' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
although i can use the command line, i can't use mysql workbench, it gives me an error:
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: 111
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 putting my ip address and/or "localhost" as the hostname, but i get the same problem.
what can i do???
Last edited by infernalarch (2010-11-11 16:11:07)
Offline
default mysql doesn't start with networking support. you need to adjust your my.cnf
Give what you have. To someone, it may be better than you dare to think.
Offline
default mysql doesn't start with networking support. you need to adjust your my.cnf
could you tell me exactly what do i have to modify??
Offline
wonder wrote:default mysql doesn't start with networking support. you need to adjust your my.cnf
could you tell me exactly what do i have to modify??
In my.cnf:
change
bind-address = 127.0.0.1
to
bind-address = 0.0.0.0
restart server
Offline
infernalarch wrote:wonder wrote:default mysql doesn't start with networking support. you need to adjust your my.cnf
could you tell me exactly what do i have to modify??
In my.cnf:
change
bind-address = 127.0.0.1
to
bind-address = 0.0.0.0restart server
not enough and kinda stupid to listen to all interfaces(security problem). you only need to comment out skip-networking
Last edited by wonder (2010-11-12 18:47:57)
Give what you have. To someone, it may be better than you dare to think.
Offline
whatshisname wrote:infernalarch wrote:could you tell me exactly what do i have to modify??
In my.cnf:
change
bind-address = 127.0.0.1
to
bind-address = 0.0.0.0restart server
not enough and kinda stupid to listen to all interfaces(security problem). you only need to comment out skip-networking
You learn something new every day. But the original poster will also have to comment out: "bind-address = 127.0.0.1" as well, won't he? At least that what I had to do on my workstation.
Offline
wonder wrote:whatshisname wrote:In my.cnf:
change
bind-address = 127.0.0.1
to
bind-address = 0.0.0.0restart server
not enough and kinda stupid to listen to all interfaces(security problem). you only need to comment out skip-networking
You learn something new every day. But the original poster will also have to comment out: "bind-address = 127.0.0.1" as well, won't he? At least that what I had to do on my workstation.
i put the skip-networking line as a comment and still can't get workbench to work, by the way i do not have the line "bind-address = 127.0.0.1"
i´really don't know what to do..
please help.
Offline
Offline