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 vote289 views1 answer
Stored procedure function relation
SQL
0 vote241 views1 answer
Postgresql subquery
SQL
0 vote280 views1 answer
Oracle winter time change
SQL
1 vote283 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote257 views1 answer
Mysql update table from select on another table
SQL
2 votes261 views2 answers
Postgres select duplicate columns
SQL
0 vote272 views1 answer
Express api ith mysql data
SQL
1 vote251 views1 answer
Alter table column size oracle
SQL
4 votes236 views1 answer
Oracle show error line number
SQL
7 votes280 views2 answers
MySQL IF without else
SQL