Fedora 5 and mysql

Discussion in 'Installation/Configuration' started by Xenobi, Jul 26, 2006.

  1. Xenobi

    Xenobi New Member

    Hopefully I have an easy problem, as I'm new to linux. :p

    While following The Perfect Setup for Fedora Core 5, I came to MySQL.
    Everything seemed to go very well until I got here.

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

    which responded with

    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'


    I searched for answers and found some info specific to mysql. I used the mysql> query prompt to enter

    set password for 'root'@'localhost' = password ('newpassword');

    Which seemed to work! but the same command with

    set password for 'root'@'myhostname' = password ('newpassword');

    only returns an arrow ->


    mysql> select user, host, password, select_priv, update_priv, delete_priv, insert_priv from mysql.user;

    only shows the localhost with a password.

    Anybody know what I'm doing wrong? Thanks!
  2. Destroyer

    Destroyer New Member

  3. Xenobi

    Xenobi New Member


    I appreciate the reply. I think I have it all figured out now. :p

Share This Page