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 vote234 views1 answer
Sql cursor example multiple columns
SQL
3 votes223 views2 answers
Sqlite show table structure
SQL
2 votes204 views1 answer
Enum in SQL Server
SQL
0 vote209 views1 answer
Sql server create constraint
SQL
12 votes235 views6 answers
Distinct in sql server
SQL
0 vote219 views2 answers
Disallowed function mysql to_date()
SQL
0 vote200 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
1 vote222 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote209 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
2 votes267 views5 answers
Tablespace ORACLE
SQL