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 vote178 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote245 views1 answer
Sql get table last modified time
SQL
5 votes176 views2 answers
Sql conn
SQL
6 votes182 views3 answers
How to delete table sqlite
SQL
0 vote194 views1 answer
Mysql reset wp_options
SQL
13 votes176 views2 answers
Mysql order by multiple columns
SQL
0 vote214 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
1 vote188 views1 answer
Error code 1292 mysql workbench
SQL
0 vote193 views3 answers
Sql delete all except
SQL
-1 vote181 views1 answer
Ssms connect with connection string
SQL