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