DBA Hub

📋Steps in this guide1/1

Grant privileges to user in mysql

Examples on GRANT command

mysql configurationintermediate
by MYSQL
19 views
1

Grant privileges to user in mysql

Examples on GRANT command

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
GRANT ALL PRIVILEGES ON *.* to 'user_name'@'localhost';
GRANT ALL PRIVILEGES ON *.* to 'user_name'@'%';
GRANT ALL PRIVILEGES ON *.* to 'user_name'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* to 'user_name'@'%' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON dbname.* to 'user_name'@'localhost';
GRANT ALL PRIVILEGES ON dbname.* to 'user_name'@'%';
GRANT INSERT,UPDATE,DELETE ON TABLE DBNAME.TABLENAME TO 'user_name'@'localhost';
GRANT INSERT,UPDATE,DELETE ON TABLE DBNAME.TABLENAME TO 'user_name'@'%';
GRANT CREATE ON DATABASE.* to 'user_name'@'localhost';
GRANT CREATE ON DATABASE.* to 'user_name'@'%';
GRANT SELECT , EXECUTE ON DATABASE.* to 'user_name'@'%';
GRANT SELECT , EXECUTE ON DATABASE.* to 'user_name'@'localhost';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!