Hello Mr Paharenko,
I have started it with mysqld_safe & and I also tried /etc/rc.d/init.d/mysql start
Funny thing is that after install the the mysql and test databases are empty so I've tried mysql_install_db which runs but the databases remains empty as well.
It is weird. I've done so many MySQL installations under Linux and they are usually so smoth. Any version I try to install on this machine such as 4.0.24 and 4.0.20 is not successful.
So I believe that there must be a missing library on this machine. It is a dual PIII Xenon 500Mhz Compaq Server with 2GB of RAM and a Raid system. It is running a smp kernel
2.6.10-1.770_FC3smp
I am attaching the files for you. As you can see it only has the process number and that it started and ended right away. Again, the base mysql database cannot be created. So I wonder, is there any app missing?
If I still FC3 full I can get it running if I remove the original series 3.x and put 4.x Then if I still a clean FC3 and try 4.0 it does not work. Any clues?
The attached file is myhost.err under /var/lib/mysql that I've renamed to mysql.log
mysqld.log is under /var/log/ and it has the errors
Thank you in advance,
C.F.
Gleb Paharenko wrote:
Hello.
under /var/lib/mysql saying mysqld started and mysqld ended.
It is unusual behavior of MySQL to leave the error files without clues. Please, send us the contents of this file.
The tables are not created not even if I run mysql_install_db.
According to the manual they should be installed automatically, when you're using RPM distribution.
How do you start the MySQL server?
"C.F. Scheidecker Antunes" <[EMAIL PROTECTED]> wrote:
Hello,
I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp
It is a dual Xenon PIII server.
I am trying to install MySQL 4.0.24 as I usually do:
- There are no other mysql servers present, no 3.x as I did not install it.
- I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm It installs the server
Then I try to run MySQL but it does not run. Instead I have a .err file under /var/lib/mysql saying mysqld started and mysqld ended.
I have done so many MySQL installs before and so I cannot understand why I cannot install it now on this server.
The tables are not created not even if I run mysql_install_db.
Is there any dependency that is missing? Any necessary library?
Any ideas?
Thank you,
C.F.
050314 02:22:28 mysqld started 050314 02:22:28 mysqld ended
050314 02:27:47 mysqld started 050314 02:27:47 mysqld ended 050314 02:28:00 mysqld started 050314 02:28:00 mysqld ended
050314 01:30:52 mysqld started 050314 01:30:52 mysqld ended 050314 01:30:58 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050314 1:30:58 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050314 1:30:59 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... 050314 1:30:59 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 050314 1:31:02 InnoDB: Started 050314 1:31:02 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:31:02 Aborting 050314 1:31:02 InnoDB: Starting shutdown... 050314 1:31:06 InnoDB: Shutdown completed 050314 1:31:06 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:31:06 mysqld ended 050314 01:31:32 mysqld started 050314 1:31:32 InnoDB: Started 050314 1:31:32 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:31:32 Aborting 050314 1:31:32 InnoDB: Starting shutdown... 050314 1:31:35 InnoDB: Shutdown completed 050314 1:31:35 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:31:35 mysqld ended 050314 01:32:03 mysqld started 050314 1:32:03 InnoDB: Started 050314 1:32:03 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:32:03 Aborting 050314 1:32:03 InnoDB: Starting shutdown... 050314 1:32:05 InnoDB: Shutdown completed 050314 1:32:05 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:32:05 mysqld ended 050314 01:32:41 mysqld started 050314 1:32:41 InnoDB: Started 050314 1:32:41 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:32:41 Aborting 050314 1:32:41 InnoDB: Starting shutdown... 050314 1:32:43 InnoDB: Shutdown completed 050314 1:32:43 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:32:43 mysqld ended 050314 01:32:58 mysqld started 050314 1:32:59 InnoDB: Started 050314 1:32:59 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:32:59 Aborting 050314 1:32:59 InnoDB: Starting shutdown... 050314 1:33:01 InnoDB: Shutdown completed 050314 1:33:01 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:33:01 mysqld ended 050314 01:34:13 mysqld started 050314 1:34:13 InnoDB: Started 050314 1:34:13 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:34:13 Aborting 050314 1:34:13 InnoDB: Starting shutdown... 050314 1:34:15 InnoDB: Shutdown completed 050314 1:34:15 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:34:15 mysqld ended 050314 01:36:43 mysqld started 050314 1:36:43 InnoDB: Started 050314 1:36:43 /usr/sbin/mysqld-max: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2) 050314 1:36:43 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:36:43 Aborting 050314 1:36:43 InnoDB: Starting shutdown... 050314 1:36:46 InnoDB: Shutdown completed 050314 1:36:46 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:36:46 mysqld ended 050314 02:16:01 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 050314 2:16:01 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 050314 02:16:01 mysqld ended 050314 02:16:16 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 050314 2:16:16 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 050314 02:16:16 mysqld ended 050314 02:16:48 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 050314 2:16:48 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 050314 02:16:48 mysqld ended
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]