« Return to Thread: Problem on creating root password

Problem on creating root password

by satimis :: Rate this Message:

Reply to Author | View in Thread

Hi folks,

CentOS 4.4 amd64

I have been stuck on creating root password;

# mysqladmin -u root password yourrootsqlpassword[code]
Access denied for user ‘root’@'localhost’ (using password: NO)
[/code]

# su -
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


B.R.
satimis

 « Return to Thread: Problem on creating root password