MYSQL 初始体验

1）MYSQL与Oracle的区别
昨天试了一个mysql，db、user概念与oracle的大不相同。oracle 的db包含user,user对应一个tbs，对应一个schemal；mysql的user可以对应多个db,db的概念等同于schemal。
IN MYSQL:
server instance == not identified with catalog, just a set of databases
database == schema == catalog == a namespace within the server.
user == named account, who can connect to server and use (but can not own - no concept of ownership) objects in one or more databases
to identify any object you need (database name + object name)

IN ORACLE:
server instance == database == catalog == all data managed by same execution engine
schema == namespace within database, identical to user account
user == schema owner == named account, identical to schema, who can connect to database, who owns the schema and use objects possibly in other schemas
to identify any object you need (schema name + object name)