MySQL4 installed but mysqladmin prevents me from making changes...

[Randell D.]

Folks,

I've been using MySQL 3.23 for a number of months - I've got familiar with
the everyday stuff (read/write/sort) but access or grant management still
remains foreign.

After a recent hack attempt on my server, I decided to be safe and
re-install everything (its a LAMPhp server on a SuSE 8.1 box). Everything
looks fine with the exception of my MySQL installation. I am installing it
via an rpm - I've tried using both version 3 and version 4 but both give me
the same problem. When I install the server and client, and then execute
the following on the server

# /usr/bin/mysqladmin -u root -h 192.168.1.3 password elephant

I get the message

error: 'Host 'stanley.mydomain.com' is not allowed to connect to this MySQL
server.

I have two network cards on the box (192.168.1.3 ad 192.168.1.2). I've
tried using each of their IP addresses, and localhost, but none seem to
work. I had a previous working version of MySQL Control Center on my WinMe
box which I have also tried to use, but it has started to fail during bot
with the message "Mysqlcc has caused an error in QT-MT312.DLL. Mysqlcc will
now close." This error repeats even after a reboot or re-install.

Can someone advise me as to how I can proceed as this is the only thing that
is holding me up from continuing with my project work... Please share via
newsgroup for all to learn as I note there seems to be frequent posts with
regards to access problems... I'd prefer to stick with latest production
version 4 (though I have no problems rolling back to 3.23 if need be).

Thanks in advance,
Randell D.