Thursday 5 October 2017

How to Use MySQL GRANT to Grant Privileges to Account

MySQL GRANT Statement Syntax:

MySQL provides you with the statement that allows you to grant access privileges to database accounts. MySQL GRANT The following illustrates the GRANT statement syntax:


Privileges:  indicates the privileges that you assign to the account. For example, the privilegeCREATE allows an account to Create Database and Create Tables. You can grant multiple privileges using single statementGRANT; the privileges are separated by commas.

No comments:

Post a Comment

How to find table row count?

--Use below query to find table row count select so.name,sp.rows from sys.objects so inner join sys.partitions sp on so.object_id = sp.obj...