mysql_fix_privilege_tables error

i have a problem with update mysql db after several automatic update security and patch via yast. I have used opensuse 11 x64 version on my rigs

here my konsole log report


linux-gjgd:/home/brigs # touch /var/lib/mysql/.run-mysql_upgrade
linux-gjgd:/home/brigs # rcmysql restart
Restarting service MySQL
Shutting down service MySQL                                           done
Updating MySQL privilege database...
Looking for 'mysql' in: /usr/bin/mysql
Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck
Running 'mysqlcheck'...
Running 'mysql_fix_privilege_tables'...
ERROR 1005 (HY000) at line 7: Can't create table 'db' (errno: 13)
ERROR 1005 (HY000) at line 12: Can't create table 'host' (errno: 13)
ERROR 1005 (HY000) at line 15: Can't create table 'user' (errno: 13)
ERROR 1005 (HY000) at line 21: Can't create table 'func' (errno: 13)
ERROR 1005 (HY000) at line 24: Can't create table 'tables_priv' (errno: 13)
ERROR 1005 (HY000) at line 26: Can't create table 'columns_priv' (errno: 13)
ERROR 1005 (HY000) at line 29: Can't create table 'help_topic' (errno: 13)
ERROR 1005 (HY000) at line 32: Can't create table 'help_category' (errno: 13)
ERROR 1005 (HY000) at line 35: Can't create table 'help_relation' (errno: 13)
ERROR 1005 (HY000) at line 38: Can't create table 'help_keyword' (errno: 13)
ERROR 1005 (HY000) at line 41: Can't create table 'time_zone_name' (errno: 13)
ERROR 1005 (HY000) at line 44: Can't create table 'time_zone' (errno: 13)
ERROR 1005 (HY000) at line 47: Can't create table 'time_zone_transition' (errno: 13)
ERROR 1005 (HY000) at line 50: Can't create table 'time_zone_transition_type' (errno: 13)
ERROR 1005 (HY000) at line 53: Can't create table 'time_zone_leap_second' (errno: 13)
ERROR 1005 (HY000) at line 56: Can't create table 'proc' (errno: 13)
ERROR 1005 (HY000) at line 59: Can't create table 'procs_priv' (errno: 13)
ERROR 1017 (HY000) at line 75: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 79: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 81: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 82: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 83: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 86: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 87: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 88: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 94: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 99: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 105: Can't find file: './mysql/tables_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 108: Can't find file: './mysql/tables_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 117: Can't find file: './mysql/tables_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 131: Can't find file: './mysql/columns_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 135: Can't find file: './mysql/columns_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 145: Can't find file: './mysql/columns_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 153: Can't find file: './mysql/func.frm' (errno: 13)
ERROR 1017 (HY000) at line 161: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 163: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 174: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 180: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 190: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 193: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 197: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 200: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 201: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 202: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 203: Can't find file: './mysql/func.frm' (errno: 13)
ERROR 1017 (HY000) at line 207: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 211: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 236: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 241: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 255: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 259: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 273: Can't find file: './mysql/func.frm' (errno: 13)
ERROR 1017 (HY000) at line 275: Can't find file: './mysql/func.frm' (errno: 13)
ERROR 1017 (HY000) at line 282: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 287: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 288: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 290: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 291: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 293: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 294: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 299: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 300: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 302: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 303: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 305: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 306: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 311: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 317: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 322: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 323: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 325: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 326: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 328: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 329: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 334: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 335: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 337: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 338: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 340: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 341: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 343: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 344: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 346: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 347: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 352: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 353: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 354: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 359: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 366: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 368: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 369: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 370: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 378: Can't find file: './mysql/procs_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 382: Can't find file: './mysql/procs_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 386: Can't find file: './mysql/procs_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 390: Can't find file: './mysql/procs_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 398: Can't find file: './mysql/proc.frm' (errno: 13)
ERROR 1017 (HY000) at line 442: Can't find file: './mysql/proc.frm' (errno: 13)
ERROR 1017 (HY000) at line 444: Can't find file: './mysql/proc.frm' (errno: 13)
FATAL ERROR: Upgrade failed
                                                                      failed

Any suggestion ??

Who owns the files in /var/lib/mysql/mysql? Hopefully it’s mysql:mysql. If they are owned by some other account (perhaps due to running mysql as root), that’s a problem.

Change its ownership to mysql.mysql solved the prob