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 vote169 views1 answer
Sql decimal to 2 places
SQL
0 vote143 views1 answer
Logtash mysql cofiguration file
SQL
0 vote157 views1 answer
Sql max of two values
SQL
0 vote137 views1 answer
How to move a columns location in mysql
SQL
1 vote142 views1 answer
Too many connections mysql
SQL
0 vote159 views1 answer
Mysql get only the field names in a table
SQL
16 votes160 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote159 views1 answer
Postgresql inline table
SQL
1 vote103 views1 answer
Mysql show attributes of a table
SQL
0 vote157 views1 answer
Create view in sql server that contain multiple select statements
SQL