[SOLVED] change root password error in mysql

jitendra.sharma · 03-12-2013, 04:24 AM

whenever i type the command for root user with pasword redhat
#mysqladmin -u root password redhat
i getting error
"can't turn off logging error access denied"
Please guide me what should i do.........

jschiwal · 03-12-2013, 05:09 AM

Firstly, there is a difference between the mysql root user and the system root user. Don't run the mysql client as root.
If you've never given msql's root user a password use:

Code:

 mysqladmin -u root password NEWPASSWORD

If the root account has a password, you need to enter the old password to authenticate:

Code:

 mysqladmin -u root -p'oldpassword' password NEWPASSWORD

jitendra.sharma · 03-12-2013, 05:46 AM

jschiwal, thnks for reply.
Actuly i didn't give any password to root i want to assign the password to root user... as per your first step i did the configuration but i got the same error which i mantion above.......

jitendra.sharma · 03-12-2013, 08:59 AM

http://muthusaravananmca.wordpress.c...-centos-5-5-5/
i solved my problem with above links thanks.