PDA

View Full Version : Perfect Server Cent OS 5.3 Mysql problems


uvstudios
23rd May 2009, 00:22
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.

falko
23rd May 2009, 14:59
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.
That's exactly the problem. Take a look at chapter 10 on http://www.howtoforge.com/perfect-server-fedora-10-p4