In a multiusers base database ,it is necessary to create users who can access a database to certain part or whole. This is necessary from security point of view.
Now we can divide the security into two groups
- System security--deals with access and operational level
- Data security--deals with use of database.
The syntax is--
Create user 'user_name' identified by 'password';
well let's see in practical...
Here I have created an user with username as 'xxxx'...this user's password will be 'yyyy'
image credit: http://webindiasolutions.com/blog/wp-content/uploads/2011/11/3D_Data_Base.jpg