Hi everybody,
when I execute this command as a su:
mysql --user=root --password resourcedb

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

I wanted to use my home directory as the repository for my database, so
I created a link between /var/lib/mysql/ with my /home/mysql/data file
with: ln -s /var/lib/mysql /home/edward/mysql/data

preceded by: chown -Rf mysql:mysql data

And in my /home/mysql/data directory contain these file
links_db/ localhost.err mysql.sock=
links_db2/ localhost.pid /resourcedb mysql@

And I am using Linux-Mandrake

Any idea how can I solve this problem?

Thanks so much for your time.

Regards
Edward
SINGAPORE

When running your mysql command, is mysqld even running to connect to at all?

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!


there is no mysql.sock on my slackware
i did install th database and it gave no errors.
i also dont have any init.d in my rc.d dirctory

when i start mysqld it says cannot run as root.
followed the sslamp guide posted in some other thread.

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

now where do i do that when i dont have init.d

etc/init.d links to what??