I changed mysql root password and I cant access It. password contained some chars

Question

using this command I changed root password

 mysqladmin -u root password fg$pkh@567fghu 

And now I cant access mysql. Is this because mysql parse the chars other than what I expect?
Also I completely removed and installed mysql and Problem is extant.
How do I remove mysql so that I get rid of password?

Answer 1

It looks like you need to reset your password you can try this it should work

service mysqld stop mysqld_safe --skip-grant-tables & mysql --user=root mysql update user set Password=PASSWORD('new-password') where user='root'; flush privileges; exit; 

Now stop mysql

pkill mysql 

and restart the service

service mysql start 

You should be able log on with your new password.