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

1 vote75 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
5 votes116 views3 answers
Truncate function in sql oracle
SQL
6 votes111 views1 answer
Oracle desc table primary key
SQL
0 vote108 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote98 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote112 views1 answer
OFFSET consulta mysql
SQL
3 votes108 views2 answers
Tsql join multiple record in one string
SQL
1 vote103 views2 answers
How to check username in mysql command line
SQL
1 vote103 views1 answer
Select statement to print longest name
SQL
0 vote100 views2 answers
Sqlalchemy core in clause
SQL