/SQL/Mysql grant all privileges to user from any host

Mysql grant all privileges to user from any host

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 grant all privileges to user from any host

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

Similar codes

10 votes214 views4 answers
Mysql if else
SQL
1 vote107 views1 answer
Oracle get current schema
SQL
0 vote141 views1 answer
Sql alter column name sql server
SQL
3 votes110 views1 answer
Sql server version query
SQL
0 vote113 views1 answer
Mysql create pool
SQL
2 votes126 views1 answer
Query to find table size in oracle 12c
SQL
11 votes107 views1 answer
Get ddl materialized view oracle
SQL
0 vote115 views1 answer
Check database restore status sql script
SQL
1 vote106 views1 answer
Mysql history command
SQL
0 vote117 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL