Mysql problems

How can i remove mysql and install a fresh copy and with default settings because i messed up everything.can somebody give me the exact guide.

 

Which distribution do you use?

 

I use centos 5.3 x86_64

 

I manage to sort that out,the problem was the user-priviledges, now i got the problem with clamd.It fails to restart

This is the error:
[root@server1 ~]# service clamd start
Starting Clam AntiVirus Daemon: LibClamAV Error: cli_loaddbdir(): Can't open directory /var/clamav
ERROR: Can't open file or directory
[FAILED]

And got this in the messages:

Oct 20 06:55:49 server1 clamd[4200]: No stats for Database check - forcing reload
Oct 20 06:55:49 server1 clamd[4200]: Reading databases from /var/clamav
Oct 20 06:55:51 server1 clamd[4200]: Database correctly reloaded (632783 signatures)
Oct 20 06:58:53 server1 clamd[4424]: clamd daemon 0.95.2 (OS: linux-gnu, ARCH: x86_64, CPU: x86_64)
Oct 20 06:58:53 server1 clamd[4424]: Running as user clamav (UID 101, GID 105)
Oct 20 06:58:53 server1 clamd[4424]: Log file size limit disabled.
Oct 20 06:58:53 server1 clamd[4424]: Reading databases from /var/clamav
Oct 20 06:58:53 server1 clamd[4424]: Not loading PUA signatures.
Oct 20 06:58:53 server1 clamd[4424]: Can't open file or directory
I'm using centos 5.3

Please help.

 

What's the output of

Code:

ls -la /var/

?

 

[root@server1 ~]# ls -la /var/
total 228
drwxr-xr-x 28 root root 4096 Oct 20 06:30 .
drwxr-xr-x 24 root root 4096 Oct 20 00:14 ..
drwxr-xr-x 2 root root 4096 Oct 20 12:00 account
drwxr-x--- 6 amavis amavis 4096 Oct 20 06:36 amavis
drwxr-xr-x 13 root root 4096 Oct 20 12:15 cache
drwxr-xr-x 2 clamav clamav 4096 Oct 21 04:02 clamav
drwxr-xr-x 2 root root 4096 Mar 17 2007 cvs
drwxr-xr-x 3 root root 4096 Oct 20 12:00 db
drwxr-xr-x 3 root root 4096 Oct 20 12:03 empty
drwxr-xr-x 3 root root 4096 Oct 20 12:03 ftp
drwxr-xr-x 2 root root 4096 Mar 11 2009 games
drwxrwx--T 2 root gdm 4096 Sep 5 23:07 gdm
drwxr-xr-x 32 root root 4096 Oct 20 04:58 lib
drwxr-xr-x 2 root root 4096 Mar 11 2009 local
drwxrwxr-x 5 root lock 4096 Oct 21 04:04 lock
drwxr-xr-x 17 root root 4096 Oct 21 04:04 log
lrwxrwxrwx 1 root root 10 Oct 20 11:56 mail -> spool/mail
drwxr-x--- 5 root named 4096 Jul 30 02:54 named
drwxr-xr-x 2 root root 4096 Mar 11 2009 nis
drwxr-xr-x 2 root root 4096 Mar 11 2009 opt
drwxr-xr-x 2 root root 4096 Mar 11 2009 preserve
drwxr-xr-x 2 root root 4096 Jan 21 2009 racoon
drwxr-xr-x 25 root root 4096 Oct 21 22:14 run
drwxr-xr-x 18 root root 4096 Oct 20 05:47 spool
drwxrwxrwt 2 root root 4096 Oct 21 04:02 tmp
drwx------ 2 root root 4096 Jan 7 2007 tux
drwxr-x--- 2 amavis amavis 4096 Jul 19 15:59 virusmails
drwxr-xr-x 8 root root 4096 Jul 14 12:06 www
drwxr-xr-x 3 root root 4096 Oct 20 12:03 yp

 

Ok, what's the output of

Code:

ls -la /var/clamav/

?