change the group
chown -R mysql.daemon /dir/name try that On Tuesday 25 October 2005 16:05, Michael McFadden wrote: > Hi. > > Looks like the 'hosts' grant table is missing, > corrupt, or does not have permissions set correctly. > > My examples come from version 4.1 I hope they apply, > or at least point you in the right direction. > > My datadir is /var/lib/mysql - your's may be different > > within the datadir there is another directory 'mysql' > - (/var/lib/mysql/mysql/) these are where the grant > tables live. > > within that directory, you should have these: > -rw-rw---- 1 mysql mysql 9064 2005-10-24 15:21 > host.frm > -rw-rw---- 1 mysql mysql 0 2005-10-24 15:21 > host.MYD > -rw-rw---- 1 mysql mysql 1024 2005-10-24 15:21 > host.MYI > > make sure they > 1) exsist > 2) owned by the mysql user (in my case, 'mysql') > 3) readable, writeable by 'mysql' (of course) > > You can also attempt to rerun 'mysql_install_db' to > recreate the grant tables. > > Please read > http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html > for more information on the mysql_install_db script. > > Also, if you are upgrading from 4.1 to 5.0, you may > need to run 'mysql_fix_privelage_tables' to add > aditional columns to your existing tables. This is > probably not the case, tho. > > Hope that helps you! > > -Mike > > --- tom wible <[EMAIL PROTECTED]> wrote: > > >Description: > > > > [EMAIL PROTECTED] > > mysql-standard-5.0.15-linux-i686]# Starting mysqld > > daemon with databases from > > /usr/local/mysql-standard-5.0.15-linux-i686/data > > STOPPING server from pid file > > /usr/local/mysql-standard-5.0.15-linux-i686/data/tomsEmachine.pid > > > 051024 19:52:09 mysqld ended > > > > [EMAIL PROTECTED] > > mysql-standard-5.0.15-linux-i686]# cat > > /var/lib/mysql/tomsEmachine.err > > 051024 18:38:27 mysqld started > > InnoDB: The first specified data file ./ibdata1 did > > not exist: > > InnoDB: a new database to be created! > > 051024 18:38:28 InnoDB: Setting file ./ibdata1 size > > to 10 MB > > InnoDB: Database physically writes the file full: > > wait... > > 051024 18:38:28 InnoDB: Log file ./ib_logfile0 did > > not exist: new to be > > created > > InnoDB: Setting log file ./ib_logfile0 size to 5 MB > > InnoDB: Database physically writes the file full: > > wait... > > 051024 18:38:29 InnoDB: Log file ./ib_logfile1 did > > not exist: new to be > > created > > InnoDB: Setting log file ./ib_logfile1 size to 5 MB > > InnoDB: Database physically writes the file full: > > wait... > > InnoDB: Doublewrite buffer not found: creating new > > InnoDB: Doublewrite buffer created > > InnoDB: Creating foreign key constraint system > > tables > > InnoDB: Foreign key constraint system tables created > > 051024 18:38:29 InnoDB: Started; log sequence > > number 0 0 > > 051024 18:38:29 [ERROR] Fatal error: Can't open and > > lock privilege > > tables: Table 'mysql.host' doesn't exist > > 051024 18:38:30 mysqld ended > > > > 051024 19:54:03 mysqld started > > 051024 19:54:03 InnoDB: Database was not shut down > > normally! > > InnoDB: Starting crash recovery. > > InnoDB: Reading tablespace information from the .ibd > > files... > > InnoDB: Restoring possible half-written data pages > > from the doublewrite > > InnoDB: buffer... > > 051024 19:54:03 InnoDB: Starting log scan based on > > checkpoint at > > InnoDB: log sequence number 0 36808. > > InnoDB: Doing recovery: scanned up to log sequence > > number 0 43655 > > 051024 19:54:04 InnoDB: Starting an apply batch of > > log records to the > > database... > > InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 > > 13 14 15 16 17 18 > > 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 > > 36 37 38 39 40 41 42 > > 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 > > 60 61 62 63 64 65 66 > > 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 > > 84 85 86 87 88 89 90 > > 91 92 93 94 95 96 97 98 99 > > InnoDB: Apply batch completed > > 051024 19:54:04 InnoDB: Started; log sequence > > number 0 43655 > > 051024 19:54:04 [ERROR] Fatal error: Can't open and > > lock privilege > > tables: Table 'mysql.host' doesn't exist > > 051024 19:54:04 mysqld ended > > > > >Submitter-Id: airdrummer > > >Originator: tom wible > > >Organization: > > >MySQL support: none > > >Synopsis: demon quits immediately > > >Severity: critical > > >Priority: <[ low | medium | high ] (one line)> > > >Category: mysql > > >Class: sw-bug > > >Release: mysql-5.0.15-standard (MySQL Community > > > > Edition - Standard > > (GPL)) > > > > >C compiler: gcc (GCC) 3.2.3 20030502 (Red Hat > > > > Linux 3.2.3-52) > > > > >C++ compiler: gcc (GCC) 3.2.3 20030502 (Red Hat > > > > Linux 3.2.3-52) > > > > >Environment: > > > > <machine, os, target, libraries (multiple > > lines)> > > System: Linux tomsEmachine 2.6.11-1.1369_FC4 #1 Thu > > Jun 2 22:55:56 EDT > > 2005 i686 i686 i386 GNU/Linux > > Architecture: i686 > > > > Some paths: /usr/bin/perl /usr/bin/make > > /usr/bin/gmake /usr/bin/gcc > > /usr/bin/cc > > GCC: Using built-in specs. > > Target: i386-redhat-linux > > Configured with: ../configure --prefix=/usr > > --mandir=/usr/share/man > > --infodir=/usr/share/info --enable-shared > > --enable-threads=posix > > --enable-checking=release --with-system-zlib > > --enable-__cxa_atexit > > --disable-libunwind-exceptions > > --enable-libgcj-multifile > > --enable-languages=c,c++,objc,java,f95,ada > > --enable-java-awt=gtk > > --with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre > > > --host=i386-redhat-linux > > Thread model: posix > > gcc version 4.0.0 20050519 (Red Hat 4.0.0-8) > > Compilation info: CC='gcc' CFLAGS='' CXX='gcc' > > CXXFLAGS='' > > LDFLAGS='' ASFLAGS='' > > LIBC: > > lrwxrwxrwx 1 root root 13 Jun 19 21:47 > > /lib/libc.so.6 -> libc-2.3.5.so > > -rwxr-xr-x 1 root root 1489572 May 30 08:05 > > /lib/libc-2.3.5.so > > -rw-r--r-- 1 root root 2523698 May 30 08:44 > > /usr/lib/libc.a > > -rw-r--r-- 1 root root 238 May 30 07:10 > > /usr/lib/libc.so > > lrwxrwxrwx 1 root root 10 Jun 19 23:31 > > /usr/lib/libc-client.a -> c-client.a > > lrwxrwxrwx 1 root root 16 Jun 19 23:31 > > /usr/lib/libc-client.so -> > > libc-client.so.0 > > -rwxr-xr-x 1 root root 773464 Mar 2 2005 > > /usr/lib/libc-client.so.0 > > Configure command: ./configure > > '--prefix=/usr/local/mysql' > > '--localstatedir=/usr/local/mysql/data' > > '--libexecdir=/usr/local/mysql/bin' > > '--with-comment=MySQL Community > > Edition - Standard (GPL)' > > '--with-extra-charsets=complex' > > '--with-server-suffix=-standard' > > '--enable-thread-safe-client' > > '--enable-local-infile' '--enable-assembler' > > '--disable-shared' > > '--with-big-tables' '--with-readline' > > '--with-archive-storage-engine' > > '--with-innodb' 'CC=gcc' 'CXX=gcc' > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ > Yahoo! FareChase: Search multiple travel sites in one click. > http://farechase.yahoo.com -- -- Fanaticism consists of redoubling your effort when you have forgotten your aim. -- George Santayana -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
