/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 vote158 views1 answer
Output table plsql
SQL
0 vote177 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote176 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote171 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote194 views1 answer
Reset postgres table index to next max value
SQL
0 vote164 views1 answer
Postgres drop type
SQL
0 vote183 views1 answer
Turn on foreign keys check mysql
SQL
27 votes186 views6 answers
Set password mysql
SQL
4 votes160 views1 answer
Mysql copy table with new name
SQL
12 votes170 views1 answer
Docker mysql random root password
SQL