MySQL - FATAL ERROR: Upgrade failed

4 Dec 2007

      Hallo zusammen,

stehe vor einem Rätsel.
will MySQL starten und erhalte folgende Meldung:

elbe:/ # mysqladmin -u root -h localhost password "rootpassword"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through 
socket '/var/lib/mysql/mysql                                                           .sock' 
(2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' 
ex                                                           ists!
elbe:/ # 

"mysql.sock" existiert scheinbar nicht - jedenfalls nicht in dem Pfad.

andere Meldung ist folgende:

#######################################
elbe:/ # rcmysql start
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
elbe:/ #  

###########################

Installiert ist MySQL 5.0.45
Was versucht das System zu finden?
Was fehlt denn?

Scon einmal vielen Dank für die Mühe,
bis dann
Heiner

-- 
****************************************************
Heiner Gewiehs # Marketing-Fachkfm.
Krimhildstr.7 # 63868 Großwallstadt
FON:06022-654167 # Fax:06022-656071
****************************************************
-- 
Um die Liste abzubestellen, schicken Sie eine Mail an:
    opensuse-de+unsubscribe@opensuse.org
Um eine Liste aller verfuegbaren Kommandos zu bekommen, schicken
Sie eine Mail an: opensuse-de+help@opensuse.org