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 vote189 views1 answer
Query on date sqlite flutter
SQL
0 vote194 views1 answer
Postgresql heritage
SQL
0 vote181 views1 answer
Oracle for loop on list
SQL
0 vote200 views1 answer
Netstat -tln mysql
SQL
0 vote184 views1 answer
Get yesterday date ISO in psql
SQL
2 votes206 views3 answers
Row number mysql
SQL
2 votes193 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote195 views1 answer
How to avoid duplicate records in sqlite
SQL
3 votes303 views1 answer
Sql datetime as date
SQL
28 votes190 views4 answers
Show tables mysql
SQL