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

12 votes131 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote139 views1 answer
Closure in sql
SQL
-2 votes146 views2 answers
Union vs union all in sql
SQL
1 vote143 views1 answer
Raise application error in oracle
SQL
14 votes142 views1 answer
Sql value of string
SQL
8 votes155 views1 answer
Mysql restore database
SQL
20 votes137 views3 answers
SQL query rename table
SQL
1 vote147 views1 answer
How to print longest name in sql
SQL
22 votes140 views4 answers
Mysql reset auto increment id
SQL
3 votes153 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL