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 vote229 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote163 views1 answer
Postgresql interview questions
SQL
22 votes169 views3 answers
SQL CHEATSHEET
SQL
11 votes180 views2 answers
Oracle saurce code
SQL
11 votes179 views5 answers
Laravel db facade
SQL
1 vote294 views2 answers
Postgres select from last 3 months
SQL
1 vote171 views7 answers
Filter
SQL
0 vote199 views1 answer
Compress sql file database ubuntu
SQL
0 vote196 views1 answer
Sqlcl format
SQL
1 vote130 views1 answer
Oracle boolean to varchar
SQL