mysql - problem on creating root password
CentOS 4.4 amd64
I have been stuck on creating root password;
# mysqladmin -u root password yourrootsqlpassword
# su -
Access denied for user ‘root’@'localhost’ (using password: NO)
did not help.
Pls advise how to locate mysql’s hostname.pid file?
Then to run;
# kill `cat /mysql-data-directory/host_name.pid`
mysqld_safe –skip-grant-tables &
mysqladmin -u root flush-privileges password “newpassword”
OR is there any other way to fix this problem. TIA