Profile cover photo
Profile photo
Aamir Shahzad
644 followers -
Aamir Shahzad Warraich
Aamir Shahzad Warraich

644 followers
About
Posts

Post has attachment
How to create and Drop Role in MySQL Server - MySQL DBA Tutorial
What is Role in MySQL, How to create Role and How to drop Role in MySQL Server Roles in MySQL Server really helps to group the permissions to single object ( Role) and then you can assign role to user instead of you create each user individually and then gr...
Add a comment...

Post has attachment
How to change Root password in MySQL Server - MySQL DBA Tutorial
Change password for root user in MySQL Server Scenario: You are working as MySQL Server DBA and you need you change the password for root. How would you do that? Solution: You can use mysqladmin command to change the password for root user. use below statem...
Add a comment...

Post has attachment
How to Check permissions of user/log in MySQL Server - MySQL DBA Tutorial
How to check what permissions user / login has in MySQL Server Once you are login to MySQL Server, you can run below statement to see the permission of currently login user account. MySQL > Show grants; If you want to check the permissions of other users, y...
Add a comment...

Post has attachment
How to Change Password of a user in MySQL Server - MySQL DBA Tutorial
How to change password for a user/login in MySQL Server To reset the password in MySQL for user , below statement can be used. Syntax: MySQL > SET PASSWORD FOR 'UserName'@'HostName' = PASSWORD('NewPassowrd'); Example :  Let's say that we have user TB and we...
Add a comment...

Post has attachment
How to Revoke Permissions for user in MySQL server - MySQL DBA Tutorial
How to Revoke Permissions for user/login in MySQL Server  To Revoke permissions of a user account in MySQL Server, below syntax can be used. Syntax: MySQL > REVOKE PermissionType ON Object To 'UserName'@'Host'; Example:  Let's say we have user TB and we hav...
Add a comment...

Post has attachment
How to Rename user in MySQL Server - MySQL DBA Tutorial
Rename User/Login in MySQL Server Renaming User account in MySQL Server is very easy. Use below statement to rename user in MySQL. Syntax: MySQL> RENAME USER 'Old_User_Name'@'host' TO 'New_User_Name'@'Host'; Example: Let's say that we have user 'TB' and we ...
Add a comment...

Post has attachment
How to give permission to User to Grant permissions to Other Users in MySQL Server - MySQL DBA Tutorial
How to use With Grant Option in MySQL Server If you want the user to grant privileges to other users in MySQL Server, you can use WITH GRANT OPTION. The user will be only able to GRANT the permissions he/she has. Syntax: MySQL > GRANT Permission ON Object/s...
Add a comment...

Post has attachment
Grant permission to individual fields ( Columns) in MySQL - MySQL DBA Tutorial
How to provide permission on limited columns in a table in MySQL Database  In MySQL Server you can provide permission on column level.  SELECT:  You can provide select permission on specific columns of a table. The user will be only able to select the data ...
Add a comment...

Post has attachment
How to Grant Update, Insert and Delete Permissions on a Table in MySQL Database - MySQL DBA Tutorial
How to provide Update, Delete and Insert Permissions to User on Table or Tables in MySQL Database Below Syntax can be used to provide UPDATE, Delete and Insert permission on table/s in MySQL . Syntax: If you would like to provide update, delete and insert p...
Add a comment...

Post has attachment
How to provide Select permission to limited tables in MySQL Database - MySQL DBA Tutorial
How to provide Select permissions to user on limited Tables in MySQL Database  Below Syntax can be used to provide select permission on table/s in MySQL. Syntax: To provide Select permission on Single Table in MYSQL MySQL > GRANT select ON tableName to 'Use...
Add a comment...
Wait while more posts are being loaded