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

3 votes130 views1 answer
Oracle drop user
SQL
0 vote143 views1 answer
Sql decimal to 2 places
SQL
1 vote126 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
3 votes111 views1 answer
Difference sql vs mysql
SQL
0 vote149 views1 answer
Command line mysql xampp
SQL
7 votes155 views4 answers
Mysql delete older duplicates
SQL
2 votes201 views1 answer
Oracle list grants on package
SQL
0 vote149 views2 answers
Mysql row_number() example
SQL
0 vote131 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote132 views1 answer
Power bi union columns
SQL