Thanks ... but yeas, I have done both and still got that ... that's why
I was asking the questions.
I have 3.23 that came with my Linux distribution and it's not
uninstalled -- but I don't think that should be the cause, though.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 10:36 AM
To: [EMAIL PROTECTED]
Subject: RE: MySQL 4.0 Installation Problem -- trying again
Charles,
First, you need to run the mysql_install_db script. That will
create the initial mysql database tables which is where security is
tracked. Next, you will need to use the chown command to change the
ownership of your mysql data directory (and I would include the logging
directory, too) to be owned by mysql both as user and group.
Once these two steps are finished, it should run for you.
Dave
David Christensen
Brokers International, Ltd.
1200 E Main St
PO Box 160
Panora, IA 50216
(800) 362-1097 or (641) 755-2775
[EMAIL PROTECTED]
-----Original Message-----
From: Zhao, Charles [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 12:22 PM
To: [EMAIL PROTECTED]
Subject: MySQL 4.0 Installation Problem -- trying again
OK I was wrong: those files are mentioned in the doc, but I
strictly followed the manual and I still got those errors.
The first problem is host.frm cannot be found while starting
mysqld (when starting InnoDB) (in the mysqld.log file), and the server
start aborted. The manual says script/mysql_install_db will set the
initial grant tables for me and I don't need to worrry about that before
the server starts. But I still get that error. I am logged in as
"root".
I installed Mysql on NT a long time ago and that was easy.
Any help?
Thanks.
-----Original Message-----
From: Zhao, Charles
Sent: Wednesday, January 07, 2004 5:14 PM
To: '[EMAIL PROTECTED]'
Subject: RE: MySQL 4.0 Installation Problem
Fatal error: Can't open privilege tables: Can't find
file: './mysql/host.frm' (errno 13) ...
Well, since I failed to use RPM to install MySQL 4.0
over 3.23
-- I am not sure if I have to unstall the latter before I
install the former, the manual does not mention that, I went ahead to do
a fresh binary installation of it on my Linux 7, under usr/local/
directory. Followed the manual step by step until I started the server:
/bin/mysqld_safe & (also tried it with parameter
user=mysql),
but I got "mysql ended ... [1]+ Done
./bin/mysqld_safe" msg,
and I could not run any further commands, failing with
msgs like "Can't connect to local MySQL server though socket
'/tmp/mysql.sock', Check that mysqld is running and that the socket:
'/tmp/mysql.sock' exists!"
then I found in the sql log file: "Fatal error: Can't
open privilege tables: Can't find file: './mysql/host.frm' (errno 13)
..." when starting the InnoDB tables.
Both files mysql.sock and host.frm are not mentioned in
the manual, and not found in my file system.
Any one can point out the problem?
Thanks.
-----Original Message-----
From: Zhao, Charles
Sent: Tuesday, January 06, 2004 4:53 PM
To: '[EMAIL PROTECTED]'
Subject: MySQL 4.0 Installation Problem
I have 3.23 that comes with my Linux
distribution, now
when I tried to do a rpm installation of 4.0, I got messages
like:
"warning: MySQL-server-4.0.17 ... .rpm: V3 DSA
signature: NOKEY, key ID ...,
file /usr/bin/mysql from install of
MySQL-client-4.0.17.0 conflicts with file from package
mysql-3.23.52-3
...
file /usr/shar/man/man1/ ... from install of ...
conflicts with file from package mysql-3.23...
..."
and the conflict list goes on.
The installation manual does not seem to discuss
about
such issues. Do I need to remove my 3.23 before I run the
installation?
-- but that's not what the manual says, though. The first
warning msg, is that a problem, too?
Thanks.
