Those are the default databases that comes with the setup. the "mysql" database holds info on mysql accounts. the "test" is an empty database. You should create a new database "CREATE DATABASE customers" then "use customers"... after that... you can setup the tables you mentioned.
Goodluck! Paul
At 06:34 PM 3/9/2004, Mulugeta Maru wrote:
I have used access in the past and now I have started using MySQL. I have customer table, customer order table, customer order detail table. How would I make sure that when a particular customer log-in he/she sees only the account that is set-up for them. What confused me is that MySQL has a database called mysql and a table in this database called users that is used to set a user name and password for each user. I could not figure out how a user in my case a customer that has access to a customer table could be restricted to see his/her transaction only.
Any insight is very much appreciated.
_________
Paul Rigor
[EMAIL PROTECTED]
Go Bruins!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
