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

5 votes229 views1 answer
Invalid column name sql
SQL
0 vote204 views1 answer
Rollback to name in sql
SQL
2 votes216 views2 answers
Checking data type in sql server
SQL
0 vote274 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
6 votes236 views1 answer
Oracle pl sql source
SQL
1 vote237 views1 answer
What is a Database?
SQL
1 vote210 views1 answer
Oracle db create new schema
SQL
1 vote209 views1 answer
Show table columns
SQL
47 votes232 views6 answers
Add column mysql
SQL
0 vote217 views1 answer
Insert into select with group by
SQL