assign uesrname and password

[chintupintu03]

Hi all,

While creaing a new database, how to assign username and password? Can we create different usernames and passwords for same database ?

[Roger_Ramjet]

Yes. Is the short answer. You can also set different access privileges for each user: eg. user can read all tables but only update some, and cannot change table schemas etc. See the MySQL manual for full details:

privilege system: http://dev.mysql.com/doc/mysql/en/Privilege_system.html

user amangement: http://dev.mysql.com/doc/mysql/en/User_Account_Management.html