setting up mysql

[@apje]

i just installed apache,
and i now have it running with php and no problems,
but when i tried mysql i got stuck before i even begon...
i'm running mandrake, and I can choose from a few types of mysql servers, each for another type of linux, but i don't have a clue which one i need... they're at:
http://www.mysql.com/downloads/mysql-3.23.html

could someone tell me which one i should download?

[chikn]

you could just type

urpmi mysql

[@apje]

ok, it says it allready installed...
but when i type mysql it gives an error:
[root@localhost /]# urpmi mysql
alles is al geïnstalleerd
[root@localhost /]# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@localhost /]#

[chikn]

Make sure its running

#mysqladmin status

should return something with uptime threads etc, if not then its not running

start it

#service mysql start

If that doesnt work theres some long drawn out explanation of what it might be here

http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html

Or a google search turned up this- I just dont think its running

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


This can be fixed by creating a link from the /tmp/mysql.sock file.