Arch Linux

Nathan P

Member

Registered: 2008-01-30

Posts: 93

mySQL 2002 error

Been trying to setup a MySQL database for amaroK and can't get anywhere.  Installed mysql with "Pacman -S mysql" and then proceeded to follow the instructions from AmaroK but I run into problems almost immediately.

When trying to initialize the database with the command /etc/rc.d/mysqld start I immediately get a [FAIL] and of course, without the database even running mysql can't find the socket file. and gives "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)."  I checked the my.cnf file and everything seems to be in order.  What could be causing this???

Nathan P

Member

Registered: 2008-01-30

Posts: 93

Re: mySQL 2002 error

Did some more troubleshooting, tried changing the directory MySQL puts the .sock file in and now MySQL will signal that it starts sucessfully, but when I try to do mysql -u root -p it gives the same 2002 error with a different path.  Also, stopping the mysql daemon fails every time, without exception so this leads me to believe that it isn't starting properly.  Thoughts?

Nathan P

Member

Registered: 2008-01-30

Posts: 93

Re: mySQL 2002 error

Anyone?  The problem seems common enough...

Nathan P

Member

Registered: 2008-01-30

Posts: 93

Re: mySQL 2002 error

Ugh...  Bump.