# [EMAIL PROTECTED] / 2003-03-29 21:52:18 -0500:
> I just downloaded and installed the "mysql-max-4.0.12.pkg", ran
>
> cd /usr/local/mysql
> sudo ./bin/mysqld_safe
> (Enter your password)
> (Press CTRL+Z)
> (Press CTRL+D to exit the shell)
> bg
>
> as specified in the readme. When attempting to set the root password, I
> successfully ran
> /usr/local/mysql/bin/mysqladmin -u root password 'new-password'
>
> but it choked on:
> /usr/local/mysql/bin/mysqladmin -u root -h $hostname password
> 'new-password'
>
> with the error: hostname: Undefined variable.
that's your shell speaking. IOW, unrelated to MySQL.
but that is just a half of the truth. your shell tells you that
$hostname doesn't exist, but probably goes on, and executes the
command, with "" (the empty string) substituted for the variable.
the result is:
mysqladmin -u root -h password 'new-password'
IOW, you're trying to connect to a host named password. that doesn't
exist, and mysqladmin then probably tells you something like
mysqladmin: connect to server at 'password' failed
error: 'Unknown MySQL Server Host 'password' (1)'
Check that mysqld is running on password and that the port is 3306.
You can check this by doing 'telnet password 3306'
That is *very* explicit, and you should be able to understand what
it says.
> Problem is, I'm such a Unix newbie I don't know how to retrieve the
> "hostname" it is looking for.
*what* is looking for a hostname?
did you check what the -h switch to mysqladmin does?
> I tried the name of my computer and my user name but those didn't
> work.
define "didn't work".
A piece of advice that might be welcome even though unasked for:
don't be afraid to read what the software tells you. it usually
makes perfect sense without you needing a CS degree.
and don't be afraid to think. when something doesn't work perfectly
from the start, don't close your eyes in panic and yell "help!".
using a computer is a dialogue. listen to what the computer says,
and try to understand it.
and finally: http://www.catb.org/~esr/faqs/smart-questions.html
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message. see http://www.eyrie.org./~eagle/faqs/questions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]