/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

3 votes280 views2 answers
Mysql time
SQL
0 vote294 views1 answer
Mysql disable query caching
SQL
0 vote320 views1 answer
Order child below the parent in mysqli
SQL
0 vote295 views2 answers
SQL BULK INSERT
SQL
0 vote291 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
1 vote464 views3 answers
Create table from existing table in sql
SQL
4 votes293 views2 answers
Sql table
SQL
4 votes302 views4 answers
Oracle tablespace tables list
SQL
0 vote323 views1 answer
Offset in postgresql example
SQL
3 votes287 views1 answer
Postgres update column with value from another table
SQL