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 vote153 views1 answer
Sql examples from framework
SQL
0 vote151 views1 answer
Sql server for loop
SQL
2 votes154 views1 answer
How to check grants on a package in oracle
SQL
-1 vote176 views4 answers
Sql view postgresql
SQL
0 vote148 views1 answer
Select all columns except one sql
SQL
1 vote150 views2 answers
Sql insert timestamp
SQL
0 vote178 views1 answer
Psql create usr
SQL
0 vote139 views1 answer
How to start my sql server on mac
SQL
27 votes159 views6 answers
Sql update record
SQL
0 vote149 views3 answers
How to assign custom id in mysql
SQL