I've defected... (almost)

Not totally but I'm looking at it anyway.

I am looking at migrating a db fom SQL Server to MySQL and have just
installed it under windows.

Using the command line interface I have created a new db without any
problems however the command line utility is not too user friendly and I
have downloaded other tools such as Administrator & Query Browser however
when I try to use these tools I am presented with a connect screen and
cannot get any further...

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -u root ping
mysqld is alive

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -u root -h
192.168.1.3
mysqladmin Ver 8.41 Distrib 5.0.20a, for Win32 on ia32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

------------ details
deleted--------------------------------------------------

Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
count 0
force FALSE
compress FALSE
character-sets-dir (No default value)
default-character-set (No default value)
host 192.168.1.3
port 3306
relative FALSE
shared-memory-base-name (No default value)
socket (No default value)
sleep 0
ssl FALSE
ssl-key (No default value)
ssl-cert (No default value)
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cipher (No default value)
user root
verbose FALSE
vertical FALSE
connect_timeout 43200
shutdown_timeout 3600

This states that the host is 192.168.1.3 however the following does not
work:

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin variables -u root -h
192.
168.1.3
mysqladmin: connect to server at '192.168.1.3' failed
error: 'Host 'dimension9150' is not allowed to connect to this MySQL server'

C:\Program Files\MySQL\MySQL Server 5.0\bin>

Help ?

"McHenry" <mchenry@mchenry.com> wrote in message
news:444ee787$0$30735$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
> Not totally but I'm looking at it anyway.
>
> I am looking at migrating a db fom SQL Server to MySQL and have just
> installed it under windows.
>
> Using the command line interface I have created a new db without any
> problems however the command line utility is not too user friendly and I
> have downloaded other tools such as Administrator & Query Browser however
> when I try to use these tools I am presented with a connect screen and
> cannot get any further...
>
> C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -u root ping
> mysqld is alive
>
> C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -u root -h
> 192.168.1.3
> mysqladmin Ver 8.41 Distrib 5.0.20a, for Win32 on ia32
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> ------------ details
> deleted--------------------------------------------------
>
> Variables (--variable-name=value)
> and boolean options {FALSE|TRUE} Value (after reading options)
> --------------------------------- -----------------------------
> count 0
> force FALSE
> compress FALSE
> character-sets-dir (No default value)
> default-character-set (No default value)
> host 192.168.1.3
> port 3306
> relative FALSE
> shared-memory-base-name (No default value)
> socket (No default value)
> sleep 0
> ssl FALSE
> ssl-key (No default value)
> ssl-cert (No default value)
> ssl-ca (No default value)
> ssl-capath (No default value)
> ssl-cipher (No default value)
> user root
> verbose FALSE
> vertical FALSE
> connect_timeout 43200
> shutdown_timeout 3600
>
> This states that the host is 192.168.1.3 however the following does not
> work:
>
> C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin variables -u
> root -h 192.
> 168.1.3
> mysqladmin: connect to server at '192.168.1.3' failed
> error: 'Host 'dimension9150' is not allowed to connect to this MySQL
> server'
>
> C:\Program Files\MySQL\MySQL Server 5.0\bin>
>
> Help ?
>

Solved...
The name being resolved by DNS was not matching the entry in the user table,
I checked the usertable and found the host name was 'localhost' I simply
changed this to '%' and it works perfectly now.

thanks for nothing guys