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 votes224 views1 answer
Delete all content in table mysql
SQL
2 votes237 views1 answer
How to make multiple keys as primary in bdms
SQL
2 votes244 views1 answer
Oracle apex who is connected
SQL
-1 vote224 views2 answers
Full join sql
SQL
0 vote220 views1 answer
Sql remove last x char
SQL
0 vote242 views1 answer
Select lowest values sql
SQL
0 vote237 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote244 views1 answer
Sql server set complex constraints
SQL
13 votes239 views6 answers
Restart postgresql
SQL
0 vote244 views2 answers
Sql count number of rows after group by
SQL