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 vote225 views1 answer
Mysql check table exists
SQL
2 votes234 views1 answer
Oracle to_char number format percentage
SQL
0 vote230 views1 answer
Authentication in sql server
SQL
0 vote229 views1 answer
Create mysql pool connection python flask
SQL
0 vote216 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote213 views1 answer
How to see the query of a view in mysql
SQL
2 votes228 views1 answer
Q operator in sql
SQL
0 vote238 views1 answer
Transaction database with php
SQL
3 votes312 views4 answers
Sql interview questions
SQL
2 votes243 views1 answer
Flask sqlalchemy boolean field
SQL