I'm new to this list so forgive me if I tear open old wounds..;-)
I installed MySQL 4.0.13 on my mac with OS X 10.2.6 I followed the instructions onthe mysql.com site. Everything seems to be in order until I have to do :
/usr/local/mysql/bin/mysqladmin -u root password <password>
I run this command as root user and substitute <password> for a password of my choice.
I get my original prompt back without any errors or warnings.
Now the docs say I have to do :
/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password <password>
This command is run as root user. I replace <password> with the previously mentioned password of my choice.
Now I get :
/usr/local/mysql/bin/mysqladmin: connect to server at 'Warp-into-Chaos.local.' failed
error: 'Host '192.168.1.4' is not allowed to connect to this MySQL server'
Warp-into-Chaos.local. = my computer 192.168.1.4 = my computers IP address.
I even tried to replace 'hostname' with localhost. And I get :
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Then I replaced localhost with 172.0.0.1 and I got :
/usr/local/mysql/bin/mysqladmin: connect to server at '172.0.0.1' failed error: 'Can't connect to MySQL server on '172.0.0.1' (60)' Check that mysqld is running on 172.0.0.1 and that the port is 3306. You can check this by doing 'telnet 172.0.0.1 3306'
I checked to see if mysqld was running and it was/is.
Can somebody tell me what is going on here and how I can solve this?
Kind Regards Werner van Mook