Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

[Bill Karwin]

Sounds like your data directory is in a nonstandard place, and the 'mysql' system database (which includes the mysql.host table) can't be found.

On Solaris, typical locations for the data dir should be, for example, /var/mysql or /var/lib/mysql or /usr/local/lib/mysql.

Are you overriding the default data directory location with an options file or a --datadir flag to mysqld or mysqld_safe?

Can you determine what datadir it's trying to use? (look for datadir options in the my.cnf file, mysqld_safe, or mysql.server init script). Once you determine where it's trying to look for the datadir, look in that directory. Do you see a subdirectory called "mysql" and a file "host.MYD" underneath that directory?

Regards,
Bill K.