Grant mysql

Grant all privileges mysql

/*
The GRANT statement is used to assign full control over specific database by providing all priviledge.
Follow below statement for assign priviledge to user
*/

Syntax: 
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Grant mysql

/*
The GRANT statement is used to assign full control over specific database by providing all priviledge.
Follow below statement for assign priviledge to user
*/

Syntax: 
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' WITH GRANT OPTION;

/*
I hope it will help you.
Namaste
*/

Mysql grant grant option

GRANT ALL ON *.* TO 'user'@'localhost';

GRANT GRANT OPTION ON *.* TO 'user'@'localhost';

Source: oreilly.com

Similar codes

0 vote206 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
1 vote173 views2 answers
Mysql show views
SQL
49 votes258 views6 answers
Alter table add column
SQL
5 votes179 views1 answer
Alter table add comment oracle
SQL
0 vote167 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote204 views1 answer
Query to insert image
SQL
2 votes196 views1 answer
How to show the whole table in sql
SQL
0 vote179 views1 answer
Codeigniter dbforge add index
SQL
0 vote168 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
1 vote175 views1 answer
Restart identity postgresql
SQL