mysql problem

Discussion in 'HOWTO-Related Questions' started by cipha, Jun 16, 2009.

  1. cipha

    cipha New Member

    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?
     
  2. topdog

    topdog Active Member HowtoForge Supporter

    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
     
  3. cipha

    cipha New Member

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

    HooGLaNDeR New Member

    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
     
  5. cipha

    cipha New Member

    if i do that, i get this

    mysqladmin: Unknown command: 'sqlrootpassword'
     
  6. cipha

    cipha New Member

    resolved

    I have resolved my issue

    thanks to all for their input
     
  7. HooGLaNDeR

    HooGLaNDeR New Member

    If you share your solve with the others, some day another might find the solution to his similar issue ;)
     
  8. cipha

    cipha New Member

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

Share This Page