GRANT SELECT, UPDATE ON databaseName.* : Grant : Privilege MySQL TUTORIALS

MySQL TUTORIALS » Privilege » Grant »

GRANT SELECT, UPDATE ON databaseName.*


GRANT SELECT, UPDATE ON databaseName.*
TO 'user1'@'domain1.com' IDENTIFIED BY 'pw1'
WITH GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50;


mysql>

Related Scripts with Example Source Code in same category :

Granting Privileges on the new database
A user doesn't need a password if connecting from a certain machine
WITH GRANT OPTION condition allows the user to give others privileges to that database
GRANT ALL
Add localhost to mysql table for accessing sample_db
Grant Select and Update privilege to a user
Grant select, update privilege for a remote user
GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50

MySQL TUTORIALS

Privilege
» Grant

Aggregate Functions

Cast Functions Operators

Comparison Functions Operators

Control Flow Functions

Cursor

Data Dictionary

Data Types

Database

Date Time Functions

Encryption Compression Functions

Information Functions

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Miscellaneous Functions

Privilege

Subquery

Table

Table Join

Trigger

View

GRANT SELECT, UPDATE ON databaseName.* : Grant : Privilege MySQL TUTORIALS

MySQL TUTORIALS » Privilege » Grant »

GRANT SELECT, UPDATE ON databaseName.*

Leave a Comment / Note

MySQL TUTORIALS