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

2 votes231 views3 answers
How to check current user in mySQL
SQL
0 vote208 views1 answer
Mysql query single row
SQL
3 votes204 views1 answer
What is having clause
SQL
0 vote232 views1 answer
Mysql backup query
SQL
1 vote229 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote261 views1 answer
Jpa generationtype sequence mysql
SQL
1 vote204 views1 answer
Select from describe sql
SQL
2 votes238 views1 answer
Create mysql user on all hosts
SQL
0 vote223 views1 answer
Case insensitive sql
SQL
0 vote210 views1 answer
Drop check command
SQL