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 vote271 views1 answer
Import sql file in mysql linux
SQL
0 vote325 views1 answer
Search In the Data using ObjectName
SQL
0 vote324 views1 answer
Sql counter column
SQL
2 votes353 views2 answers
Postgres add column integer
SQL
1 vote323 views3 answers
Psql fatal database does not exist
SQL
-1 vote306 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote326 views1 answer
Sql contains vs like
SQL
0 vote285 views1 answer
Testing sql queries
SQL
13 votes353 views5 answers
Alter table query sql server change column
SQL
0 vote346 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL