/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 vote135 views1 answer
Mysql terminal run sql file
SQL
7 votes142 views6 answers
Group_concat in mysql
SQL
0 vote146 views2 answers
Collation in sql
SQL
2 votes114 views1 answer
Ifnull postgres
SQL
0 vote126 views1 answer
Sql query interview questions githu
SQL
1 vote119 views1 answer
Use of now() in mysql
SQL
0 vote137 views1 answer
Mssql disable foreign key constraint
SQL
0 vote158 views1 answer
When mysql server would not work in xampp
SQL
22 votes231 views4 answers
Tsql rename table
SQL
0 vote128 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL