I'm experiencing some problems while trying to change mysql's root password
I have just installed mysql in redhat. I am trying to execute /usr/bin/mysqladmin -u root password "password" but it is showing some error as below
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
I have tried "service mysqld start" but its showing some error
Starting MySQL..The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).
please help me