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 vote169 views1 answer
Import sql file in mysql linux
SQL
-2 votes202 views1 answer
Modify column name in tsql
SQL
3 votes202 views1 answer
Fk in insert mysql
SQL
0 vote204 views1 answer
Drop database using terminal postgres
SQL
2 votes204 views2 answers
Change mysql password from command line
SQL
5 votes206 views2 answers
To date oracle
SQL
6 votes193 views2 answers
Oracle
SQL
0 vote193 views1 answer
Add column to table with default value plsql
SQL
0 vote206 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote188 views1 answer
Mysql identified by syntax error
SQL