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 vote297 views3 answers
How to pass password to mysql command line
SQL
0 vote264 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
4 votes275 views3 answers
Mysql update with join
SQL
0 vote279 views1 answer
Less than date query sqlachemy
SQL
0 vote301 views2 answers
Port 5432 is already in use mac
SQL
0 vote273 views1 answer
Sql insert from excel
SQL
3 votes276 views1 answer
RENAME table pl sql
SQL
2 votes291 views1 answer
Mysql set value as null
SQL
1 vote299 views3 answers
Reseed sql table primary key
SQL
0 vote293 views1 answer
Spark sql grows beyond 64 kb
SQL