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

0 vote335 views1 answer
What does leave do in mysql
SQL
0 vote330 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote312 views1 answer
Disableforiegn key check
SQL
2 votes299 views1 answer
Convert series number to date in sql
SQL
0 vote305 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote336 views2 answers
Py sqlite if entry exists
SQL
0 vote323 views1 answer
Replace string in whole database mysql stackoverflow
SQL
2 votes341 views2 answers
Mysql add hours to time field
SQL
1 vote331 views1 answer
What is int in mysql
SQL
0 vote348 views1 answer
Alter table add check constraint oracle
SQL