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 vote122 views1 answer
Sql server order by nulls last
SQL
0 vote138 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote125 views1 answer
Mysql sum per week
SQL
1 vote126 views1 answer
Sql select row with max date
SQL
1 vote122 views2 answers
Postgres copy table from one schema to another
SQL
0 vote124 views1 answer
Mysql begin statement
SQL
0 vote126 views1 answer
Postgres meta command to show all rows in table
SQL
2 votes138 views2 answers
Mysql on duplicate key update get value from values
SQL
1 vote144 views1 answer
Mysql show long running queries
SQL
3 votes128 views3 answers
How to add month in update sql
SQL