mysql error message on installation?

infernalarch · 2010-11-11 16:10:53

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)

wonder · 2010-11-11 16:13:18

default mysql doesn't start with networking support. you need to adjust your my.cnf

infernalarch · 2010-11-12 15:08:15

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??

whatshisname · 2010-11-12 18:44:01

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.0

restart server

wonder · 2010-11-12 18:47:18

whatshisname wrote:

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.0
restart 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)

whatshisname · 2010-11-12 19:58:34

wonder wrote:

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.0
restart 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.

infernalarch · 2010-11-13 21:32:53

whatshisname wrote:

wonder wrote:
whatshisname wrote:
In my.cnf:
change
bind-address = 127.0.0.1
to
bind-address = 0.0.0.0
restart 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.

lonre · 2011-01-17 15:58:08

add

 mysqld : 127.0.0.1 : ALLOW

to

 /etc/hosts.allow

here: https://wiki.archlinux.org/index.php/LAMP

Arch Linux

#1 2010-11-11 16:10:53

mysql error message on installation?

#2 2010-11-11 16:13:18

Re: mysql error message on installation?

#3 2010-11-12 15:08:15

Re: mysql error message on installation?

#4 2010-11-12 18:44:01

Re: mysql error message on installation?

#5 2010-11-12 18:47:18

Re: mysql error message on installation?

#6 2010-11-12 19:58:34

Re: mysql error message on installation?

#7 2010-11-13 21:32:53

Re: mysql error message on installation?

#8 2011-01-17 15:58:08

Re: mysql error message on installation?

Board footer