MYSQL - After install

[Patrick Newberry]

Not sure but seemed to have problem in the set up  my root password:
...<snip>...
Setting up mysql-server-5.0 (5.0.22-0ubuntu6.06.2) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
.

<So far so good>

goshawk at gypsyfarm:~$ mysqladmin
mysqladmin  Ver 8.41 Distrib 5.0.22, for pc-linux-gnu on i486
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

Administration program for the mysqld daemon....<snip>

<then try using xxxxxx as password in this example goshawk is the user I
am logged into ubuntu with>

goshawk at gypsyfarm:~$ mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'goshawk'@'localhost' (using password:
NO)'
goshawk at gypsyfarm:~$ mysqladmin -u root password xxxxxx

<then>
goshawk at gypsyfarm:~$ mysqladmin -h goshawk at localhost -u root -p password
xxxxxx Enter password:

mysqladmin: connect to server at 'goshawk at localhost' failed
error: 'Unknown MySQL server host 'goshawk at localhost' (2)'
Check that mysqld is running on goshawk at localhost and that the port is
3306.
You can check this by doing 'telnet goshawk at localhost 3306'
goshawk at gypsyfarm:~$ mysqladmin -h root at localhost -u root -p password
xxxxxx
Enter password:
mysqladmin: connect to server at 'root at localhost' failed
error: 'Unknown MySQL server host 'root at localhost' (2)'
Check that mysqld is running on root at localhost and that the port is
3306.
You can check this by doing 'telnet root at localhost 3306'
goshawk at gypsyfarm:~$ mysqladmin -h root at gypsyfarm -u root -p password
xxxxxx
Enter password:
mysqladmin: connect to server at 'root at gypsyfarm' failed
error: 'Unknown MySQL server host 'root at gypsyfarm' (2)'
Check that mysqld is running on root at gypsyfarm and that the port is
3306.
You can check this by doing 'telnet root at gypsyfarm 3306'
goshawk at gypsyfarm:~$ mysql restart
ERROR 1045 (28000): Access denied for user 'goshawk'@'localhost' (using
password: NO)
goshawk at gypsyfarm:~$ sudo mysql restart
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)


<try to ping again>
goshawk at gypsyfarm:~$ sudo mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'



<my machine name is gypsyfarm>
<just now wondering... Maybe I should be using root at gypsyfarm ?
Machine at home so can't try till tonight.>



Pat