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

3 votes261 views1 answer
Apex call duration
SQL
4 votes182 views3 answers
Copy table postgres
SQL
3 votes246 views1 answer
Oracle nextval insert
SQL
0 vote194 views1 answer
Sql server check whether column has same equal values
SQL
4 votes208 views1 answer
Sql data types
SQL
0 vote190 views1 answer
Sql view index
SQL
0 vote203 views1 answer
Create schema sql server
SQL
34 votes232 views5 answers
Oracle alter table add column
SQL
0 vote189 views1 answer
Vbscript create ADODB.Connection
SQL
1 vote327 views1 answer
Oracle current sequence value
SQL