/SQL/Grant all priviledges to mysql user

Grant all priviledges to mysql user

Mysql grant all privileges to a user

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Source: chartio.com

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
*/

Similar codes

1 vote141 views1 answer
Get parameter value in mysql trigger
SQL
0 vote143 views1 answer
Check if mysql db is used
SQL
-2 votes178 views1 answer
Trunc in sql
SQL
0 vote136 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote122 views1 answer
Postgres data location
SQL
1 vote116 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote122 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote150 views1 answer
Time data type in mysql
SQL
0 vote119 views1 answer
Remove default constraint sql server
SQL
0 vote120 views1 answer
T-SQL Never ending DELETE
SQL