mysql problems

[spyd4r]

hello i am using the gentoo distro, and i have tried both the ebuild and from source and i cannot get mysql to work..i have made sure i have unix socket support in my kernel... i just dunno what to do, i always get this error..i was unable to get any answers from the gentoo forum....
:/

please help


root@spyder mp3sb_serv # mysql -u root -p < MySQL_create_Table.sql
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[monkeyboi]

u need to run the server first...

if u jux got mysql installed...

try to do the followin...

create an unprivilege user called mysql

then
cd /to/the/path/where/u/installed/mysql
./scripts/mysql_install_db

now that u initialize the database...
u need to run the server...

cd /to/the/path/where/u/installed/mysql
./bin/safe_mysqld
while u'r in the same path create the root password for mysql

./bin/mysqladmin -u root password anypassword

then u can now
type mysql -u root -p root_password_that_u_just_entered

[spyd4r]

i've done that...i used both the ebuild from gentoo and the latest source.....same thing from both

[monkeyboi]

type ps -aux | grep mysql
to check if it's running

when u run it... don't cd to the bin folder

like jux say u installed mysql in /usr/local/mysql
all the executable will be in /usr/local/mysql/bin

don't cd /usr/local/mysql/bin
and run the mysql server from there...

cd /usr/local/mysql
then
./bin/safe_mysqld


for some reason if u run the safe_mysqld like this ./safe_mysqld
it wont work...

after u run the safe_mysqld it should display some msgs....
saying mysql started using database from /var/xxx....