well, i've got /var/lib/mysql:
[EMAIL PROTECTED] mysql]$ ll /var/lib/mysql/
total 20524
-rw-rw---- 1 mysql mysql 10485760 Oct 24 18:38 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Oct 24 19:54 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Oct 24 18:38 ib_logfile1
-rw-rw---- 1 mysql root 2102 Oct 24 19:54 tomsEmachine.err
and /usr/local/mysql/data/mysql:
[EMAIL PROTECTED] data]$ ll /usr/local/mysql/data
total 12
drwxr-x--- 2 tomw mysql 4096 Oct 24 19:52 mysql
drwxr-x--- 2 tomw mysql 4096 Oct 17 07:21 test
-rw-rw---- 1 tomw mysql 666 Oct 24 19:54 tomsEmachine.err
note the identical datestamps on the 2 .err files...
anyway, i chown'd mysql:mysql /usr/local/mysql/data/mysql/* & reran
scripts/mysql_install_db and got this:
[EMAIL PROTECTED] mysql]$ ./scripts/mysql_install_db
mkdir: cannot create directory `/var/lib/mysql/mysql': Permission denied
chmod: cannot access `/var/lib/mysql/mysql': No such file or directory
mkdir: cannot create directory `/var/lib/mysql/test': Permission denied
chmod: cannot access `/var/lib/mysql/test': No such file or directory
Installing all prepared tables
051026 19:59:20 [Warning] Can't create test file
/var/lib/mysql/tomsEmachine.lower-test
Fill help tables
051026 19:59:20 [Warning] Can't create test file
/var/lib/mysql/tomsEmachine.lower-test
so i
chown'd mysql:mysql /usr/local/mysql (for some reason, i had 2 do that as root,
even tho i owned the dir tree...wtf?-)
su mysql
and ./scripts/mysql_install_db ran successfully, creating the /var/lib/mysql
datafiles.
and ./bin/mysqld_safe seems 2 have worked...
oh, wait: ./bin/mysqladmin -u root password '<newpassword>' gives me this:
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
bash-3.00$ ls -l /tmp/mysql.sock
ls: /tmp/mysql.sock: No such file or directory
bash-3.00$ ps -ef | grep mysql
root 2121 2092 0 20:15 pts/7 00:00:00 su mysql
mysql 2122 2121 0 20:15 pts/7 00:00:00 bash
mysql 2211 2122 0 20:21 pts/7 00:00:00 /bin/sh ./bin/mysqld_safe
mysql 2232 2211 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2233 2232 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2234 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2235 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2236 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2237 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2239 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2240 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2241 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2242 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2294 2122 0 20:26 pts/7 00:00:00 ps -ef
mysql 2295 2122 0 20:26 pts/7 00:00:00 grep mysql
bash-3.00$ ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
fixed that;-)
oh, wait:
bash-3.00$ ./bin/mysqladmin -u root password '<new-passwd>'
bash-3.00$ ./bin/mysqladmin -u root -h tomsEmachine password '<new-passwd>'
./bin/mysqladmin: connect to server at 'tomsEmachine' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
thanx 4 all the help...weird how there were 2 sets of db files, the disconnect
on the .sock, and then the password fubar...but then that's what makes linux so
much not-read4primetime-fun;-}
David Ziggy Lubowa wrote:
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
