setting up an internal TLD

[Kenny Mann]

Mike Taylor wrote:
 > 1234567890123456789012345678901234567890123456789012345678901234567890
 > There might be a problem after all.
 >
 > I installed the mysql-server-5.0.22 package.  When I tried to set the
 > root passwords, the command:
 >
 > /usr/local/bin/mysqladmin -u root password <password>
 >
 >
 > worked fine, but when I tried to run:
 >
 > /usr/local/bin/mysqladmin -u root -h homebox.localnet.dot password 
<password>
 >
 >
 > I got the message:
 >
 > /usr/local/bin/mysqladmin: connect to server at 
'homebox.localnet.dot' failed
 > error: 'Host 'homebox.localnet.dot' is not allowed to connect to this 
MySQL server'
 >
 >
 >
 > I'm guessing that it's an error with MySQL and not DNS.  I don't know 
anything about databases though.
 >

Ok, the problem is a MySQL config.
Basically, you need to allow root to connect from other machines -- 
unless the mysql daemon is local to the box you are trying to connect from?

I'm about to go to work or I'd put more nfo here, but this should get 
you where you need to be:

http://www.google.com/search?q=host+is+not+allowed+to+connect+to+mysql+server

The first 6 or so links should be applicable, I think (unless they 
changed just now).

If you login locally (local to MySQL daemon) and attempt to connect with:
/usr/local/bin/mysqladmin -uroot -p -h 127.0.0.1
Does it work?

(the -p basically has it prompt you instead of typing it on the command 
line)

-- Kenny