Red Hat Bugzilla – Bug 46165
rpm installation fails to run mysql_install_db
Last modified: 2007-04-18 12:34:12 EDT
From Bugzilla Helper:
User-Agent: Mozilla/4.76 [en] (X11; U; Linux 2.4.2-2 i686)
Description of problem:
The original installation (upgrade) of mysql from the 7.1 dist disk fails,
and a subsequent rpm -e and rpm -ivh of the mysql-* files from disk 2 fail
to run mysql_install_db. This results in failure of safe_mysqld & failing
because there is no mysql database in the home directory (/var/lib/mysql).
Steps to Reproduce:
1. rpm -ivh all of the mysql-* files on disk 2 of the 7.1 workstation
release. don't forget the perl-DBD-MySQL* rpm
Actual Results: the rpm -ivh of mysql-3.23... should have run
mysql_install_db. It doesn't, so you don't get the "you just installed
mysql and here's what you do next" text message (about a page). Trying to
start the server with safe_mysqld & fails because there is no mysql
database at /var/lib/mysql
Expected Results: mysql_install_db should be run and create the mysql
database, allowing the server startup.
I worked around this by running mysql_install_db manually, but that had a
subsequent failure. I ran it as root and it created the mysql database and
the test database owned by root and in the root group. This caused
safe_mysqld & to fail (noted in the /var/log/ error log) because it
"couldn't find host.frm", one of the tables in mysql. Once I changed owner
and group of all database files to mysql, it started normally.
You shouldn't run mysql_install_db at all - or safe_mysqld, for that matter. Use
"service mysqld start", which automatically will initialize the database on the
The "not a bug" response from teg addresses the problem caused by attempting to
start the system with mysql_install_db and safe_mysqld (BTW, where is the
'service mysql start' solution documented??). That was an attempted workaround
for the rpm installation failure.
It does NOT address the problem that all of this is supposed to be run during
the RPM installation of the mysql-3.23...rpm file, which I (great leap here)
assume operates like the latest version from mysql.com.
No, they are different from the ones on mysql.com - and they don't run this
during rpm install because it is run automatically the first time you start
mysql ("service mysqld start")