okay so here is my problem i have followed the guide and for some reason when i am executing
mysqladmin -h server1.ctforce.net -u root password ********
I get the following error:
mysqladmin: connect to server at 'server1.ctforce.net' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
You have new mail in /var/spool/mail/root
I was able to do the first step of setting up fine
mysqladmin -u root password yourrootsqlpassword
but as soon as i moved onto the next section i get errors
I've checked my /etc/hosts and its output is:
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 server1.ctforce.net server1 localhost.localdomain localhost
192.168.0.100 server1.ctforce.net server1
::1 localhost6.localdomain6 localhost6
in 127.0.0.1 it seems like there is too much information in there and that possible server1.ctforce.net shouldnt even be in that section. But i'm not sure.