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 vote386 views1 answer
Data directory postgresql
SQL
1 vote392 views1 answer
Mysql breakline on string
SQL
0 vote355 views1 answer
Sqlite closes value
SQL
1 vote369 views1 answer
How to show index type in postgresql
SQL
0 vote371 views1 answer
How to get data from 2 database
SQL
1 vote365 views1 answer
Postgresql export output table as a csv
SQL
32 votes451 views6 answers
Rename column mysql
SQL
0 vote423 views1 answer
Query for backup a database at another location in file system
SQL
1 vote349 views1 answer
Oracle rolling back transactions
SQL
23 votes367 views1 answer
How remove column in mysql
SQL