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

1 vote122 views2 answers
Extract weekday from date in sql
SQL
2 votes106 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
1 vote126 views2 answers
Intersect sql
SQL
0 vote121 views1 answer
Get initials name in sql
SQL
31 votes117 views3 answers
Sql count(*)
SQL
17 votes128 views5 answers
Order by sql
SQL
1 vote97 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote116 views1 answer
Csv to sqlite python
SQL
3 votes119 views1 answer
Oracle user privileges
SQL
0 vote127 views1 answer
Sql declare variable single line
SQL