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 vote209 views1 answer
Select the date 30 days less that the todays date sql request
SQL
9 votes210 views2 answers
Oracle all tables in schema
SQL
0 vote172 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote184 views1 answer
Sql find gaps in date ranges
SQL
0 vote211 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote175 views1 answer
Java sql insert return id
SQL
1 vote322 views1 answer
Sql check roles
SQL
47 votes278 views6 answers
Add column mysql
SQL
6 votes166 views1 answer
Rank function in oracle with example
SQL
0 vote233 views1 answer
Oracle temporary table
SQL