/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 vote212 views1 answer
Top 3 salary in sql
SQL
0 vote201 views1 answer
Hibernate show sql xml property
SQL
7 votes157 views1 answer
Alter table add key sql
SQL
0 vote246 views3 answers
Mysql keyword search
SQL
1 vote193 views1 answer
Error code 1292 mysql workbench
SQL
0 vote244 views1 answer
Oracle temporary table
SQL
0 vote201 views1 answer
Oracle calculate statistics on partition
SQL
-1 vote187 views2 answers
Get day in sql
SQL
0 vote194 views1 answer
See the structure of a table mysql
SQL
0 vote190 views1 answer
Mysql export search results
SQL