Schemas = Databases
Schemas <> Database Users
In SQL Server, I believe you are referring to the ability to do:
SELECT * FROM my_database.dbo.my_table
correct?
However, AFAIK, a *schema* means a database, not a user.
In MySQL, you can have multiple schemas: simply do:
SELECT fields FROm my_schema.my_table;
You can have multiple users, however, you do not reference the user in your SQL statements. Users are simply authenticated upon login and checked for privileges (permissions, in SQL Server terms) upon query execution.
HTH,
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com