C.F. Scheidecker Antunes wrote:
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
