imported tables cannot be edited any longer
Uwe Brauer <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hello I presume I mis configured my mysql, since the following happens in 1.1.3 spanish and 1.1.4 english: When I try to copy and paste the contents of a scalc document into a table of my mysql base (odbc or mysql driver) then everything goes fine, the table seems editable, however closing and reopen the database windows, displays something odd, the new table cannot be edit, that is now values can be inserted, when I chose edit table, there are *no* fields visible! I applied various time the famous ignore-the-driver-priv macro but without any result. The really odd thing is that I can create a table edit and so on. Only the importation seem now to work, I had to play around with mysql_setpermisson etc since I had other problems but For example mysqlaccess oub test mysqlaccess Version 2.06, 20 Dec 2000 By RUG-AIV, by Yves Carlier ([email protected]) Changes by Steve Harvey ([email protected]) This software comes with ABSOLUTELY NO WARRANTY. Access-rights for USER 'oub', from HOST 'localhost', to DB 'test' +-----------------+---+ +-----------------+---+ | Select_priv | Y | | Show_db_priv | Y | | Insert_priv | Y | | Super_priv | Y | | Update_priv | Y | | Create_tmp_table_priv | Y | | Delete_priv | Y | | Lock_tables_priv | Y | | Create_priv | Y | | Execute_priv | Y | | Drop_priv | Y | | Repl_slave_priv | Y | | Reload_priv | Y | | Repl_client_priv | Y | | Shutdown_priv | Y | | Ssl_type | ? | | Process_priv | Y | | Ssl_cipher | ? | | File_priv | Y | | X509_issuer | ? | | Grant_priv | N | | X509_subject | ? | | References_priv | Y | | Max_questions | 0 | | Index_priv | Y | | Max_updates | 0 | | Alter_priv | Y | | Max_connections | 0 | +-----------------+---+ +-----------------+---+ BEWARE: Everybody can access your DB as user `oub' from host `localhost' : WITHOUT supplying a password. : Be very careful about it!! The following rules are used: db : 'localhost','test','oub','Y','Y','Y','Y','Y','Y','N','Y','Y','Y' ,'Y','Y' host : 'Not processed: host-field is not empty in db-table.' user : 'localhost','oub','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','0','0','0' So that looks ok to me, does anybody has a clue? Uwe PS needless to say that everything worked fine a couple of days ago.