MySQL Bugs: #25163: Missing mysql.plugin table after installation from RPM

Bug #25163	Missing mysql.plugin table after installation from RPM
Submitted:	18 Dec 2006 23:34	Modified:	19 Jan 2007 4:39
Reporter:	Michal Ludvig	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S3 (Non-critical)
Version:	5.1.12	OS:
Assigned to:		CPU Architecture:	Any

Description:
During installation of MySQL-*-5.1.12-0.glibc23.x86_64.rpm on OpenSUSE 10.2 I got the following error:

suse102amd64:/net/marvin/data/dist/MySQL # rpm -ivh *
Preparing...                ########################################### [100%]
   [...]
   4:MySQL-server           ########################################### [100%]
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
061219 12:14:36 [ERROR] Can't open the mysql.plugin table. Please run the mysql_upgrade script to create it.

So I did mysql_upgrade and got:
~# mysql_upgrade
Can't find program '/bin/mysqlcheck'
Please restart with --basedir=mysql-install-directory

"mysql_upgrade --basedir=/usr" finally started but failed with:
# mysql_upgrade --basedir=/usr
[...]
mysql.user             OK
ERROR 1060 (42S21) at line 28: Duplicate column name 'File_priv'

(which IIRC is harmless, but anyway).

So the two problems here are
1) mysql.plugin isn't created automatically
2) mysql_upgrade doesn't know where to look for the binary

It's a first installation of MySQL on a fresh OpenSUSE system. 

How to repeat:
Follow the steps described above

Thank you for a problem report. Please, try to repeat with a newer version, 5.1.14, and inform about the results.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".