I installed the MySQL binary (4.0.11-gamma package) on my Mac OS X machine (version 10.2.4) and I couldn't get it to start up. When I run bin/mysqld_safe, I kept getting the error "Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist" [note: I later figured out that I *think* I'm getting this error because my machine does not have a recognizable hostname (i.e. you can't look it up via normal DNS)]. After mucking around for quite a while without much success, I decided to start over and reinstall from scratch. So, I deleted my mysql directory and reinstalled from the Package. Now, when I try to run bin/mysqld_safe, I get the following error: "InnoDB: Operating system error number 13 in a file operation." It looks like when you reinstall from the package, it skips the step where it changes file permissions of the data directory and its subdirectories.
>How-To-Repeat:
On a fresh MacOS X 10.2.4 system, (1) install the 4.0.11-gamma package, (2) delete the mysql directories (the /usr/local/mysql link and /usr/local/mysql-standard-4.0.11-gamma-apple-darwin6.4-powerpc directory), (3) install the 4.0.11 package again, (4) run bin/mysqld_safe.
>Fix:
Change the file permissions of the data directory and its subdirectories. Ideally, this would be fixed within the Package installer, but a release note or something would work as well.
>Submitter-Id: Perry Arnold/[EMAIL PROTECTED] >Originator: >Organization: <organization of PR author (multiple lines)> >MySQL support: none >Synopsis: MacOS Installation Bug >Severity: serious >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-4.0.11-gamma-standard (Official MySQL-standard binary)
>C compiler: gcc (GCC) 3.1 20020420 (prerelease)
>C++ compiler: gcc (GCC) 3.1 20020420 (prerelease)
>Environment:
PowerMac Dual 1.25Ghz/OS X 10.2.4
System: Darwin localhost 6.4 Darwin Kernel Version 6.4: Wed Jan 29 18:50:42 PST 2003; root:xnu/xnu-344.26.obj~1/RELEASE_PPC Power Macintosh powerpc
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/3.1/specs
Thread model: posix
Apple Computer, Inc. GCC version 1175, based on gcc version 3.1 20020420 (prerelease)
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxr-xr-x 1 root wheel 15 Mar 3 18:32 /usr/lib/libc.dylib -> libSystem.dylib
Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--disable-shared' '--with-innodb' 'CC=gcc' 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' 'CXX=gcc'
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
