I am getting this error at the time of booting of my machine and even if I want to run my mysql server by command prompt:

Error : Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
mysql ended

checked the file in /etc/rc.d/rc.mysqld, as it stated, i have to type the following comand to create the databases because slackware 10.2 won’t do that for you(as a matter of fact, i like this DO-IT-BY-MYSELF )

su - mysql
mysql_install_db

after that i get this announcement:

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root -h slacky password ‘new-password’

i can now start MySQL daemon with /usr/bin/mysqld_safe &
and i can set the root password now :)