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 vote329 views1 answer
Safe mysql
SQL
1 vote340 views1 answer
How to group by month using sql server
SQL
3 votes366 views2 answers
Check data in table mysql
SQL
1 vote341 views1 answer
Mysql backup skip table
SQL
0 vote316 views1 answer
Get duplicate entry sql
SQL
7 votes341 views2 answers
Mysql default value
SQL
0 vote354 views1 answer
Foreign key type uniqu mysql
SQL
5 votes341 views1 answer
Oracle generate list of dates in between a date range
SQL
1 vote325 views1 answer
Sql select table header
SQL
0 vote346 views1 answer
Rabbitmq ui not working
SQL