Can different users have different mysql databses on one computer ?

[jd2007]

for e.g., if i want to access all my databases, i type my password and access them...what if another users wants to create databases of his own, can he use a different password ? how to do it ?

[effigy]

Each user should have their own account in MySQL. In order for them to create databases and tables they need the CREATE privilege, which can be granted via GRANT.