Grant all privileges mysql

Mysql grant all privileges to a user

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Source: chartio.com

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 all priviledges to mysql user

/*
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 user permission database

GRANT ALL PRIVILEGES ON `db_name`.* TO 'user'@'host'

Mysql grant grant option

GRANT ALL ON *.* TO 'user'@'localhost';

GRANT GRANT OPTION ON *.* TO 'user'@'localhost';

Source: oreilly.com

Similar codes

0 vote136 views1 answer
How to add unique key constraint in mysql
SQL
2 votes122 views1 answer
Oracle sql query to make column data uppercase
SQL
1 vote141 views1 answer
Postgresql how to show table names
SQL
1 vote164 views1 answer
Drop colum oracle 18c
SQL
1 vote141 views2 answers
Postgresql check privileges on schema
SQL
0 vote164 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote131 views1 answer
Search column name sql
SQL
0 vote129 views1 answer
Postgresql create table with boolean column
SQL
0 vote134 views1 answer
Match end of string regex sql
SQL
0 vote140 views1 answer
Oracle c# multiple update sql
SQL