/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

0 vote119 views1 answer
Set default value now() date
SQL
0 vote108 views1 answer
Oracle last character of string
SQL
0 vote110 views1 answer
Sql requete number pair
SQL
0 vote105 views2 answers
How to see table associated with a schema in sql
SQL
0 vote105 views1 answer
Change default schema sql server
SQL
0 vote136 views1 answer
Postgre query date
SQL
0 vote124 views1 answer
How to get nth number in sql
SQL
0 vote118 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote117 views1 answer
Run mssql server terminal
SQL
1 vote108 views1 answer
Local sql server
SQL