thanx for your replies, but now there's another problem
the daemon is starting
# /usr/bin/mysqld_safe &
but when i run mysql as root i get the following error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
i tried to set for mysql root user by giving this command:
# /usr/bin/mysqladmin -u root password 'new-password'
now when i gave the new passwd using this command, it shows:
should i enter root passwd of the system or the one i just gave?(i may sound stupid but i've never used mysql before), anyway i tried both but it showed:
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
however i can run mysql under a normal user, but when i tried to create a database, it showed this:
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'sharath1'
i think the problem is there is no permission for any user to run mysql server in my system, how do i change it?