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 votes100 views2 answers
Having keyword sql
SQL
0 vote152 views1 answer
Selecting specific day in colum sql
SQL
7 votes100 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote96 views1 answer
Postgresql find missing id
SQL
0 vote95 views1 answer
10000000000000000000 am to meters
SQL
9 votes106 views3 answers
Mysql run sql file
SQL
57 votes256 views6 answers
Mysql alter table add column
SQL
0 vote107 views1 answer
Mysql change innodb to myisam
SQL
0 vote121 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote108 views1 answer
Postgres - Login and connect as default user
SQL