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 vote184 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
1 vote179 views1 answer
Ubuntu access database from terminal
SQL
2 votes170 views2 answers
Useradd postgres
SQL
0 vote188 views1 answer
Table user postgres
SQL
1 vote294 views3 answers
Uninstall postgresql mac
SQL
65 votes291 views6 answers
Sql add column to table
SQL
1 vote189 views1 answer
Mysql alter decimal precision
SQL
0 vote151 views1 answer
Get number of table colums in sql query
SQL
4 votes146 views1 answer
Sql list users and roles
SQL
1 vote178 views2 answers
Oracle difference between two dates in seconds
SQL