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 vote293 views1 answer
Show size of all tables postgres
SQL
0 vote294 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
1 vote295 views1 answer
Decalre temp table sql
SQL
1 vote293 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote282 views1 answer
Sql server select ignore dupplicates
SQL
0 vote285 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
5 votes295 views4 answers
Select random rows sql
SQL
50 votes422 views6 answers
Sql count duplicate rows
SQL
8 votes304 views1 answer
Oracle create datafile
SQL
0 vote326 views1 answer
Sqlalchemy _in array sqlite
SQL