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 vote140 views1 answer
Sql avg group by
SQL
9 votes187 views1 answer
No sql
SQL
0 vote164 views1 answer
Savepoint mysql script
SQL
1 vote161 views1 answer
Spark sql convert string to date
SQL
0 vote166 views1 answer
Ubuntu connect to mssql database
SQL
17 votes159 views3 answers
Postgresql list users
SQL
11 votes159 views2 answers
Sql rank
SQL
1 vote146 views1 answer
Mysql list bigger table
SQL
5 votes139 views4 answers
Rollback to in sql
SQL
0 vote155 views1 answer
Postgresql linux password
SQL