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 vote340 views1 answer
Provera dupliranih konatakata
SQL
0 vote303 views1 answer
Mysql offset from bottom
SQL
4 votes379 views1 answer
Conda install sqlalchemy
SQL
1 vote359 views1 answer
Top 10 rows in mysql
SQL
1 vote347 views1 answer
Sql delete row with auto increment
SQL
0 vote372 views1 answer
Migration graphql
SQL
0 vote369 views1 answer
List all permissions on a table in postgres
SQL
8 votes367 views5 answers
Grant permission in postgres
SQL
0 vote343 views1 answer
Search In the Data using ObjectName
SQL
0 vote347 views1 answer
Opensuse stop MySQL
SQL