can't run mysql

[nicc9]

hi, i installed apache, php, phpmyadmin and mysql on F6.

the server works great, as well as php.

when i go to phpmy admin it says:

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

when - from the terminal - i try

mysql start

i get the following error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

anybody could help me with this?

i searched on the net but couldn't find anything.

I just switched to Linux and am trying to get basic stuff working so that I can work, but so far even things that were a 2-min task as far as installation have been a nightmare.

any idea appreciated.

thanks!

[wdingus]

Common questions, did you search the forums here?

"mysql" is the _client_ not the server. Therefore you don't _start_ it, you use it to connect to the server once it's started.

Type "service mysqld start" to start the server. To set it to startup on boot from now on do so via pointy-clicky utility or "chkconfig mysqld on".

After the server is running, try "mysql" to connect to it. Once a password is set do "mysql -p" and enter the password to get the client to successfully connect to it.

For PHP, make sure package php-mysql is installed for it to be able to communicate with mysql server(s).

[nicc9]

hi wdingus.

thanks for replying.

I tried to start the service from system-config-services, but it doesn't start.

the error is:

Neither host 'localhost.localdomain' nor 'localhost' could be looked up with
/usr/bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option

I search a lot of forums and have done basically everything, but nothing has worked for me.

when I type "hostname" I get:
localhost.localdomain

any idea what else I could do?

thanks a 1000!

nicc9

[xaeth]

based on that your /etc/hosts file should have an entry that looks like this:

127.0.0.1 localhost.localdomain localhost

[nicc9]

ha!

actually I had ::1 localhost.localdomain localhost, I replaced with what you wrote and now it works (well, it's giving me an access denied error, but that I can figure out)!

thanks, thanks, thanks!