Problem in mysql : No such file or directory

[mostafa]

hello ,

I have problem in mysql server with debian system

if I writing cd user/local/mysql
get error : No such file or directory

and I can not insert new datebase get error :-
MySQL: Can't create/write to file

also MySQL server through socket '/tmp/mysql.sock' (cause all date base down)
if I writing mysqld start or restart not work and any progress for mysql not work but mysql server founded and mysql was working

maybe the error from permissions

I need help for this problem Please ..

thank you

 

[tsiou]

the (DA's default) mysql directory is
/home/mysql

run :

ls -lad /home/mysql/

you have to see this :
drwxr-xr-x 24 mysql mysql 1024 Apr 4 13:51 /home/mysql/

with ls -la /home/mysql/
you have to see something like :
drwx------ 2 mysql mysql 1536 Sep 18 2006 mysql
drwx------ 2 mysql mysql 512 Oct 3 2006 test

if the user isn't mysql do a
chown -R mysql.mysql /home/mysql