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

3 votes327 views1 answer
DB: in eloquent using sql
SQL
1 vote312 views1 answer
Import sql file mysql commadn line
SQL
0 vote379 views1 answer
How to add auto increment primary key
SQL
1 vote305 views1 answer
Return size of tables in mysql
SQL
3 votes345 views2 answers
How to delete git repo locally
SQL
1 vote340 views5 answers
What is in operator in sql
SQL
0 vote296 views1 answer
Time in sql server
SQL
0 vote315 views1 answer
Zerar auto increment mysql
SQL
3 votes298 views1 answer
Oracle wait
SQL
1 vote317 views1 answer
Describe table in sql
SQL