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

6 votes304 views5 answers
Mysql get last insert id
SQL
11 votes303 views4 answers
Query DISTINCT
SQL
4 votes302 views1 answer
Oracle select first 10 rows
SQL
5 votes315 views1 answer
How to get all dates in a month in oracle
SQL
2 votes267 views1 answer
Latest record in sql
SQL
1 vote289 views1 answer
Primary key reset in SQL database
SQL
1 vote310 views1 answer
Blob datatype in mysql
SQL
17 votes323 views6 answers
What is cursor in sql server with example
SQL
7 votes321 views2 answers
Create index mysql cli
SQL
0 vote298 views1 answer
Sql query interview questions githu
SQL