On Fri, 2 Feb 2007, Frank Bax wrote:
> I installed the Jan24 snapshot package mysql-server-5.0.27p0.tgz; then ran
> /usr/local/bin/mysql_install_db - which displays:
>
> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
> To do so, start the server, then issue the following commands:
> /usr/local/bin/mysqladmin -u root password 'new-password'
> /usr/local/bin/mysqladmin -u root -h xxxxxxxx password 'new-password'
>
> I started the mysql server, and ran the first command ok; then second command
> fails. Upon reading mysql docs, it seems a "default" install creates two rows
> (accounts) for "root" in mysql.users - the first for "localhost", the second
> for name returned by "hostname". I read that the above two commands are
> intended to make sure that passwords in both rows/accounts are updated. It
> seems the OpenBSD package only inserts one row for "root" user in mysql.user
> (with "localhost"); if this is the case, then perhaps the second command above
> should be removed from package?
>
> mysql> select host,user from mysql.user;
> +-----------+------+
> | host | user |
> +-----------+------+
> | localhost | root |
> +-----------+------+
> 1 row in set (0.03 sec)
Could it be that you named your host "localhost"?
-Otto
