Tworzenie Superusera W Mysql W Fc4

[Bioreaktor]

Witam

 

Jestem po calym dniu walki z serwerem a wlasciwie ratowania danych, no i koncze wlasnie instalacje na nowej fc4

 

Mam pytanie

 

w fedorze 4 mamy na starcie mysql'a jezeli sie nie mysql'a 5-0.4.10

 

zawsze zakladalem sobie uzytkownika superusera plikiem o tresci :

 

____

 

#

# Dumping data for table 'user'

#

 

INSERT INTO user VALUES("%", "uzytkownik", "haslo", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y");

flush privileges;

 

____

 

w nowej wersji nie widze tylu kolumien bo mamy :

 

 

mysql> use mysql

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

 

Database changed

mysql> describe user;

+-----------------------+-----------------------------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-----------------------+-----------------------------------+------+-----+---------+-------+

| Host | varchar(60) | | PRI | | |

| User | varchar(16) | | PRI | | |

| Password | varchar(41) | | | | |

| Select_priv | enum('N','Y') | | | N | |

| Insert_priv | enum('N','Y') | | | N | |

| Update_priv | enum('N','Y') | | | N | |

| Delete_priv | enum('N','Y') | | | N | |

| Create_priv | enum('N','Y') | | | N | |

| Drop_priv | enum('N','Y') | | | N | |

| Reload_priv | enum('N','Y') | | | N | |

| Shutdown_priv | enum('N','Y') | | | N | |

| Process_priv | enum('N','Y') | | | N | |

| File_priv | enum('N','Y') | | | N | |

| Grant_priv | enum('N','Y') | | | N | |

| References_priv | enum('N','Y') | | | N | |

| Index_priv | enum('N','Y') | | | N | |

| Alter_priv | enum('N','Y') | | | N | |

| Show_db_priv | enum('N','Y') | | | N | |

| Super_priv | enum('N','Y') | | | N | |

| Create_tmp_table_priv | enum('N','Y') | | | N | |

| Lock_tables_priv | enum('N','Y') | | | N | |

| Execute_priv | enum('N','Y') | | | N | |

| Repl_slave_priv | enum('N','Y') | | | N | |

| Repl_client_priv | enum('N','Y') | | | N | |

| ssl_type | enum('','ANY','X509','SPECIFIED') | | | | |

| ssl_cipher | blob | | | | |

| x509_issuer | blob | | | | |

| x509_subject | blob | | | | |

| max_questions | int(11) unsigned | | | 0 | |

| max_updates | int(11) unsigned | | | 0 | |

| max_connections | int(11) unsigned | | | 0 | |

+-----------------------+-----------------------------------+------+-----+---------+-------+

31 rows in set (0.00 sec)

 

 

po probie ywkonania skryptu mam

 

 

ERROR 1136 (21S01): Column count doesn't match value count at row 1

 

 

 

jestem za bardzo zmeczony chyba juz i nie kontaktuje , bardzo prosze Was o pomoc, abyscie mi podali ta zlota linijke )) z prawidlowo wpisanymi wartosciamii do tej wersji, albo krok po kroku komendy od utworzenia uzytkownika do konca nadawania praw aby zostal super userem bo ja juz nie mam sily hehe

 

dodam ze ostatnia wersja na ktorej dzialalem to mysql 4.0.4

 

z gory dzieki i pozdrawiam