startup mysql service

[eileen1017]

When I issued mysql -u root -p I got the following error message:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I checked the system, it's because the mysql serice is not running on the server. Our mysql admin left the company and I am taking over. I have no prior knowledge of mysql what so ever. I am having difficulty to get the service started. I googled online and tried several method, but none of them works.
I tried /etc/init.d mysql start; mysql.server start; service mysqld start. All of them returned command not found or no such directory exist. I am totally clueless at this point. Could anyone shed some light? Thank you very much.

 

[feherke]

Hi

Looks like you are using Linux. Which distribution ?


Feherke.

http://free.rootshell.be/~feherke/

 

[guelphdad]

your error message indeed confirms the server is not started.

run LOCATE mysql or WHICH mysql to find out where it is installed. i'd then suggest you change directories so you are in the /mysql/bin directory wherever that is located.

are you logged in to your system as root? if so you won't have a permission problem running mysql. if you are logged in as a regular user you may find that mysql is owned by a user called mysql and you may not have permissions to start it.