/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 vote323 views1 answer
Postgres data location
SQL
1 vote325 views1 answer
Mysql query bulk insert
SQL
26 votes333 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote327 views1 answer
Sql include rows with 0 values
SQL
0 vote341 views3 answers
Database restoring error
SQL
0 vote333 views1 answer
Oracle current timestamp
SQL
57 votes558 views5 answers
How to create a new user in postgresql
SQL
0 vote348 views1 answer
Set engine to innodb
SQL
0 vote358 views2 answers
Amazon linux postgresql client
SQL
1 vote367 views1 answer
Postgres left join
SQL