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 vote200 views1 answer
Postgresql delete limit
SQL
0 vote244 views1 answer
Mysql order by where condition sub query
SQL
0 vote224 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote166 views2 answers
Spring properties file for db
SQL
0 vote205 views1 answer
With_for_update sqlalchemy
SQL
0 vote189 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
8 votes216 views1 answer
Mysql limit rows
SQL
9 votes248 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote211 views1 answer
Get employees if not contains in sql
SQL
1 vote206 views1 answer
Sqlalchemy order by descending
SQL