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

2 votes118 views2 answers
Create table mysql integer NOT null
SQL
2 votes115 views1 answer
Oracle index size
SQL
0 vote131 views1 answer
Get only one row in mysql
SQL
0 vote117 views1 answer
Postgres get database encoding
SQL
0 vote110 views1 answer
Renombrar tabla mysql
SQL
3 votes121 views2 answers
Enter mysql command line
SQL
0 vote105 views1 answer
Mysql replication change database name
SQL
0 vote127 views1 answer
C# get sql min date
SQL
2 votes110 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
1 vote112 views2 answers
Populate sql table with random data
SQL