[cobalt-users] MySQL Install - Can't set root password

["David" <dd@xxxxxxxxxxxxxxx>]

Hi,

Trying to install MySQL on a Raq3i. When I rpm the initial file 
(raq3/MySQL-3.22.30-1.i386.rpm) here's the message I get:


MySQL
##################################################
Creating db table
Creating host table
Creating user table
Creating func table
Creating tables_priv table
Creating columns_priv table

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'

blah, blah, then:

chmod: mysql: No such file or directory
Starting mysqld daemon with databases from /var/lib/mysql

I've checked the RPM and everything appears OK, but...

1. Why would I get the "chmod: mysql: No such file or directory"
message?

2. I can't set a password using the command:

/usr/bin/mysqladmin -u root password mypassword

When I try to do this, I get this error message:

sh: /usr/bin/mysqladmin: No such file or directory

3. I've also tried doing:

UPDATE user SET Password=PASSWORD mypassword

and get the following error message:

sh: UPDATE: command not found

Any help would be much appreciated!

Thanks, .. David