Re: [Openbsd-misc] Re: mysql 4.0.18 (was: problem 3.3 --> 3.4)

["Andrea Riela" <ml@nesys.it>]

Remko Lodder wrote:
> perhaps try starting it again with a & on the end,
> 
> if you dont do that it gets active in the frontscreen, if you
> type CTRL+C or something it kills the application again.
> 
> Can you try that?

I did.
the same.

Another thing:

when I try to create mysql and test db with install_db, I see that:

observe# ./mysql_install_db --user=_mysql
Abort 
Abort 
Abort 
WARNING: The host 'observe.nesys.it' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
Abort 
Installation of grant tables failed!

Examine the logs in /var/mysql for more information.
You can also try to start the mysqld daemon with:
/usr/local/libexec/mysqld --skip-grant &
You can use the command line tool
/usr/local/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/local/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running
mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/local/bin/mysqlbug script!


What is it?
Thanks
Andrea