On 12/04/2012, at 7:12 PM, Hasse Hansson wrote: > "Googling" the problem and the error messages didn't get me much further. > > I have to admit, this is a bit over my head. aka "I don't have a clue what > I'm doing"
Why don't you go back a bit ... how did you install MySQL 5.1.62? How are you starting MySQL? (Should be in /etc/rc.conf.local, mysqld in pkg_scripts line.) Looks like two errors there - one about threading, and one about the MySQL user account. But let's not run before we walk! Working for me: $ uname -a OpenBSD xxx.yyy.co.nz 5.1 GENERIC#198 i386 $ pkg_info | grep mysql mysql-client-5.1.62 multithreaded SQL database (client) mysql-server-5.1.62 multithreaded SQL database (server) ... Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 36 Server version: 5.1.62-log OpenBSD port: mysql-server-5.1.62 ... > > > > # uname -a > > OpenBSD odin.thorshammare.org 5.1 GENERIC#160 i386 > > > > When I run : /usr/local/bin/mysql_install_db > > I get the following errormessage : > > Installing MySQL system tables... > > 120412 8:04:10 [Warning] '--skip-locking' is deprecated and will be removed > in a future release. Please use '--skip-external-locking' instead. > > 120412 8:04:10 [ERROR] Can't create interrupt-thread (error 91, errno: 91) > > > > When I try to follow some recommendations from > http://dev.mysql.com/doc/mysql-linuxunix-excerpt/5.5/en/mysql-install-db-pro > blems.html > > # /usr/local/bin/mysqld_safe --user=_mysql --skip-grant-tables & > > [1] 3016 > > # 120412 08:48:38 mysqld_safe Logging to > '/var/mysql/odin.thorshammare.org.err'. > > 120412 08:48:38 mysqld_safe Starting mysqld daemon with databases from > /var/mysql > > 120412 08:48:38 mysqld_safe mysqld from pid file > /var/mysql/odin.thorshammare.org.pid ended > > > > [1] + Done /usr/local/bin/mysqld_safe --user=_mysql --skip > > > > And the logfile says : > > 120412 08:47:40 mysqld_safe Starting mysqld daemon with databases from > /var/mysql > > 120412 8:47:41 [Warning] '--skip-locking' is deprecated and will be removed > in a future release. Please use '--skip-external-locking' instead. > > 120412 8:47:41 [ERROR] Fatal error: Can't change to run as user 'mysql' ; > Please check that the user exists! > > > > 120412 8:47:41 [ERROR] Aborting > > > > 120412 8:47:41 [Note] /usr/local/libexec/mysqld: Shutdown complete > > > > 120412 08:47:41 mysqld_safe mysqld from pid file > /var/mysql/odin.thorshammare.org.pid ended > > 120412 08:48:38 mysqld_safe Starting mysqld daemon with databases from > /var/mysql > > 120412 8:48:38 [Warning] '--skip-locking' is deprecated and will be removed > in a future release. Please use '--skip-external-locking' instead. > > 120412 8:48:38 [Note] Plugin 'FEDERATED' is disabled. > > 120412 8:48:38 InnoDB: Initializing buffer pool, size = 8.0M > > 120412 8:48:38 InnoDB: Completed initialization of buffer pool > > InnoDB: Error: pthread_create returned 91 > > 120412 08:48:38 mysqld_safe mysqld from pid file > /var/mysql/odin.thorshammare.org.pid ended > > > > Regards > > Hasse
