What does the <hostname>.err file tell you? -----Original Message----- From: Zhao, Charles [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 12:39 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MySQL 4.0 Installation Problem -- trying again
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] <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.
