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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
