Grant all privileges mysql

Mysql grant all privileges to a user

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Source: chartio.com

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 all priviledges to mysql user

/*
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 user permission database

GRANT ALL PRIVILEGES ON `db_name`.* TO 'user'@'host'

Mysql grant grant option

GRANT ALL ON *.* TO 'user'@'localhost';

GRANT GRANT OPTION ON *.* TO 'user'@'localhost';

Source: oreilly.com

Similar codes

0 vote368 views1 answer
Flask sqlalchemy session delete
SQL
1 vote398 views1 answer
Drop colum oracle 18c
SQL
2 votes385 views2 answers
How to add not null constraint in sql
SQL
0 vote335 views1 answer
Sql if else in select
SQL
0 vote396 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote353 views3 answers
Average salary in sql
SQL
0 vote338 views1 answer
Get created time of database psql 8
SQL
6 votes324 views1 answer
Oracle trigger after connect
SQL
0 vote345 views1 answer
Ksql quickstart docker
SQL
10 votes347 views6 answers
Between sql
SQL