1:23 PM
Unknown
You can add users to this database and specify the databases to which they will have access with the grant command, which has the syntax.
sql> grant all privileges on database.* to username@"servername" identified by 'password';
Example:
sql> grant all privileges on data1.* to dbuser@"localhost" identified by 'secdat';
Where data1 is the database name
dbuser is the user name who has to access the db / name of new user.
secdat is the password
If you want to restrict that user from full privilege on a db you can use the following syntax:
sql> grant CREATE,INSERT,DELETE,UPDATE,SELECT on data1.* to dbuser2@localho...
