MySQL Errors

Discussion in 'Installation/Configuration' started by Happy, Jun 3, 2007.

  1. Happy

    Happy New Member

    I am unable to login in to MYSQL. I get he following errors when running this command:
    mysqladmin -u root password

    error: 'Access denied for user 'root'@'localhost' (using password: NO)'

    prior to running the above command-I was able to set the root password when my hostname file was using the local name (server1) instead of the FDQN server1.example.com. After setting the hostname to match the hostname -f I can now not get in. How do I fix this issue

    Thanks
    Happy
     
  2. Ben

    Ben Active Member Moderator

    if you set a password for root you should also enter that the right way:

    mysql -u root -p

    then you will get prompted for the password (and it will not be written to bash's history, in comparison to write the root pw directly in the shellcommand)
     

Share This Page