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 votes103 views3 answers
Current month mysql query
SQL
0 vote97 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote98 views3 answers
Average salary in sql
SQL
10 votes111 views3 answers
Sql check double value
SQL
6 votes135 views1 answer
How to get the size of the database in postgresql
SQL
0 vote114 views1 answer
Mysql get nth highest
SQL
2 votes146 views1 answer
Tcl in sql
SQL
0 vote105 views1 answer
Sql select random procentage from rows
SQL
3 votes106 views3 answers
How to add month in update sql
SQL
-1 vote104 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL