Hopefully I have an easy problem, as I'm new to linux. 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 -> and 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!
Reset Mysql Password I had this problem once unfortunatley i cant remember how i fixed it but here is the directions to reset all passwords. Note: half way down the page skip the windows stuff Also if you have set up a FQDN for server try that instead of localhost http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Destroyer http://www.lacomputers.com.au
