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 vote327 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote292 views7 answers
Les jointures sql server
SQL
0 vote337 views1 answer
Mysql delete entire row on condition
SQL
0 vote287 views1 answer
Where case insensitive like mysql
SQL
0 vote320 views1 answer
Oracle list datafiles
SQL
0 vote372 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote279 views1 answer
Backup a table in sql
SQL
2 votes293 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote292 views3 answers
Insert or ignore postgres
SQL
11 votes302 views2 answers
Insert date sql
SQL