gentoo - MySQL Cannot Resolve Hostname -
i have problem mysql server on gentoo. when starting /etc/init.d/mysql hangs nothing happening until interrupt ctl + c. trying start mysqld directly, mysqld says:
131007 0:54:00 [error] can't start server: cannot resolve hostname!: bad message
131007 0:54:00 [error] aborting
in many forums sugested add skip-name-resolve option my.cnf. tried didn't help.
has had same problem , knows how solve issue ?
errors seeing mysql or other apps due problems in file /etc/hosts and/or /etc/conf.d/hostname. check contents of both.
you need entry in /etc/hosts hostname set /etc/conf.d/hostname executed during bootup /etc/init.d/hostname (i assume have set run in 1 of initial runlevels rc).
if have static ip, go ahead , put static ip in /etc/hosts. if using dhcp everywhere laptop, add hostname localhost ip address supposed exist regardless of whether online or not.
you should not have set skip-name-resolve in my.cnf, may avoid issues binding mysql network socket localhost via adding line: bind-address = 127.0.0.1 , removing other references other bind-addresses.
Comments
Post a Comment