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

11 votes144 views1 answer
Sql insert multiple rows from select
SQL
3 votes123 views1 answer
Oracle list user grants
SQL
0 vote134 views1 answer
Logtash mysql cofiguration file
SQL
0 vote151 views1 answer
Convert rows into columns in oracle
SQL
0 vote219 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
1 vote125 views1 answer
Regular expression in sql server
SQL
2 votes136 views2 answers
Spring where to put the data sql
SQL
5 votes157 views3 answers
Show indexes mysql
SQL
0 vote193 views1 answer
Postgres rename database
SQL
1 vote132 views1 answer
Psql connections
SQL