strange database grant to mysql database

2005-06-22 Thread Harald Falkenberg
Hallo, after creating a user via the grant command, I found that this new user can see by the 'show database' command the mysql database although the grant does not apply to it. This new user can run the 'use mysql' command, but has no access to the tables. The db table only show access grants

INNODB as default table type

2003-12-16 Thread Harald Falkenberg
Hallo, is it possible to use as a default INNODB instead of ISAM in a mysql server, so that every table, database (at least the complete server) is based on a INNODB tablespace? Is this a practical and good way to use mysql in that setup, if possible? regards Harald -- MySQL General

mysql setup compared to oracle

2003-07-16 Thread Harald Falkenberg
Hi, I'm new to mysql. Coming from the oracle database a couple of questions came up. Perhaps somebody, who has also experience in oracle, can set me on the tracks. Questions: 1. is mysql simular organized as oracle: instance/users/tables, so that I have to connect to chossen instance