/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 vote250 views2 answers
Change database postgres
SQL
2 votes300 views3 answers
Xampp mysql database not starting
SQL
0 vote277 views1 answer
Sql show table name in result
SQL
3 votes266 views2 answers
Sql get month name
SQL
0 vote267 views1 answer
Join creating duplicate columns sqllite
SQL
11 votes255 views2 answers
Safe mode off mysql
SQL
-1 vote270 views4 answers
Restart mysql server ubuntu
SQL
4 votes287 views2 answers
Oracle unlock account
SQL
0 vote261 views1 answer
Regex mongoose
SQL
1 vote267 views1 answer
How to find median of a column sql
SQL