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 vote119 views1 answer
Implicit inner join table alias with id values
SQL
27 votes118 views5 answers
Add column in table
SQL
0 vote111 views1 answer
Suse start MySQL
SQL
24 votes115 views5 answers
Sql reset auto increment
SQL
3 votes118 views1 answer
How to check schema privileges in oracle
SQL
0 vote117 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote110 views1 answer
Postgres set default schema
SQL
0 vote123 views1 answer
Oracle c# multiple update sql
SQL
2 votes126 views1 answer
Sql server find columns list in tables
SQL
0 vote118 views2 answers
How to tun mysql on ubunto
SQL