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

1 vote272 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote271 views1 answer
Mql5 list all available symbols
SQL
0 vote307 views1 answer
Mysql zerofill
SQL
0 vote271 views1 answer
SQL get max per id
SQL
0 vote303 views1 answer
Vs 2019 connect to local mysql database
SQL
5 votes293 views1 answer
Oracle list functions
SQL
0 vote280 views2 answers
Sql server select where date
SQL
1 vote301 views1 answer
Delete from inner join sql
SQL
0 vote281 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
3 votes330 views1 answer
What is having
SQL