/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 vote138 views1 answer
Update one column from another column in same table
SQL
4 votes192 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote139 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote138 views1 answer
Left join in codeigniter query builder
SQL
0 vote133 views1 answer
Date datatype in livesql
SQL
0 vote132 views1 answer
See the structure of a table mysql
SQL
16 votes153 views3 answers
Get count of duplicate records
SQL
0 vote138 views1 answer
Double in sql server example
SQL
0 vote98 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote138 views1 answer
How to import sqlite driver class in java using maven
SQL