/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
Declare date variable sql
SQL
0 vote132 views1 answer
How to change null display in psql
SQL
1 vote148 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote190 views1 answer
Store case result sql
SQL
9 votes141 views3 answers
Oracle undo usage by session
SQL
6 votes170 views1 answer
To count number of rows in SQL table
SQL
0 vote137 views2 answers
Functions with parameters SQL
SQL
0 vote139 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote155 views1 answer
Like date sql server not working
SQL
0 vote145 views1 answer
Stored function in sql
SQL