mysql problem

when i try to run this command

mysqladmin -h server1.example.com -u root password yourrootsqlpassword

i am getting this error:

mysqladmin: connect to server at 'skywalker.miragechat.co.za' failed
error: 'Access denied for user 'root'@'69.162.117.211' (using password: NO)'

please can you tell me how and where to fix it?

 

you need to run the command from the db host, by default only local users are allowed to login, as you are trying to set the password you need to do it locally then allow your remote connection

 

I am doing it locally, logged in via ssh as root

 

to give the password you need to set : -p followed by either the password, or nothing and it will prompt for the password.

example : mysqladmin -h server1.example.com -u root -p yourrootsqlpassword

 

if i do that, i get this

mysqladmin: Unknown command: 'sqlrootpassword'

 

resolved

I have resolved my issue

thanks to all for their input

 

If you share your solve with the others, some day another might find the solution to his similar issue

 

I just deleted all the users on mysql and recreated them and it worked