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 votes349 views1 answer
How to open database
SQL
0 vote315 views1 answer
Mysql select distinct date from timestamp
SQL
21 votes337 views3 answers
Average sql
SQL
0 vote306 views2 answers
How to combine two sql queries in one result
SQL
1 vote345 views1 answer
How to make a select in sql
SQL
0 vote322 views1 answer
Time in sql server
SQL
0 vote345 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
5 votes337 views1 answer
How to check port number for postgresql
SQL
0 vote357 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote331 views1 answer
Mysql local password denied
SQL