Grant mysql

Grant all privileges mysql

/*
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 database_name.* TO 'username'@'localhost';

Grant mysql

/*
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 grant option

GRANT ALL ON *.* TO 'user'@'localhost';

GRANT GRANT OPTION ON *.* TO 'user'@'localhost';

Source: oreilly.com

Similar codes

0 vote212 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote101 views1 answer
FindAllBy
SQL
1 vote158 views1 answer
What is in condition in sql
SQL
0 vote163 views1 answer
Sql select where more than one record exists
SQL
0 vote143 views2 answers
Postgresql create role
SQL
-1 vote193 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
10 votes170 views2 answers
Rtrim sql
SQL
0 vote201 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote155 views1 answer
Sql server alter table column nullable
SQL
7 votes169 views2 answers
N highest salary in sql
SQL