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 vote146 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
4 votes123 views3 answers
Drop Table Oracle
SQL
0 vote63 views1 answer
Finish transaction sql
SQL
0 vote116 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote67 views1 answer
How to fetch highest score in minimum time using mysql
SQL
11 votes101 views2 answers
Insert date sql
SQL
1 vote114 views1 answer
Mysql list bigger table
SQL
0 vote149 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote111 views1 answer
Psotgres multiple values
SQL
1 vote118 views1 answer
Mysql last year
SQL