MySQL Forums
Forum List  »  Install & Repo

Fatal error with mysqld_safe when old RPMs exist
Posted by: David Koopman
Date: July 08, 2005 09:09PM

I kept getting this error when I would start MySQL 4.1:

050707 14:46:41 Fatal error: Can't open privilege tables: File '/usr/local/mysql-4.1/share/mysql/charsets/?.conf' not found (Errcode: 2)
050707 14:46:41 Aborting
050707 14:46:41 InnoDB: Starting shutdown...
050707 14:46:43 InnoDB: Shutdown completed
050707 14:46:43 /usr/local/mysql/bin/mysqld: Shutdown complete

Notice: /usr/local/mysql/bin/mysqld (that's not what my basedir is!, it's "/usr/local/mysql-4.1"

I was starting my 4.1 server server like this:
cd /usr/local/mysql-4.1/
bin/mysqld_safe --defaults-file=/etc/my-4.1-1.cnf --max-connect-errors=10000 --user=mysql &

/etc/my-4.1-1.cnf file had basdir and data dir to match the /usr/local/mysql-4.1 directory.

Solution:

Turns out I had old RPMs installed, that were no longer needed:
MySQL-client-4.0.9-0
MySQL-devel-4.0.9-0
MySQL-Max-4.0.9-0
MySQL-shared-3.23.56-1.0.23
MySQL-4.0.9-0

I uninstalled these RPMs and now everything runs fine. Weird. Just thought I'd report it in case someone else runs into the same problem, they can look for outdated RPMs that may be interferring.

Options: ReplyQuote


Subject
Written By
Posted
Fatal error with mysqld_safe when old RPMs exist
July 08, 2005 09:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.