/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

3 votes168 views6 answers
DB::table('users')->get();
SQL
1 vote159 views1 answer
Postgres convert exisiting column to text
SQL
0 vote156 views1 answer
Addition of 2 column value in mysql
SQL
3 votes167 views2 answers
See mysql users ubuntu
SQL
0 vote176 views1 answer
Executescalar in sql server
SQL
0 vote176 views1 answer
Sql mod even odd
SQL
0 vote142 views2 answers
Add new column after in sql
SQL
0 vote169 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
21 votes162 views4 answers
Oracle add column
SQL
0 vote177 views2 answers
Unique key
SQL