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 vote109 views1 answer
Wordpress sql find and replace
SQL
0 vote102 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote110 views1 answer
Sqlite get date only
SQL
0 vote130 views1 answer
SQL Cut part string
SQL
2 votes49 views1 answer
Sql select in list
SQL
2 votes104 views1 answer
Set column to not null mysql
SQL
0 vote127 views1 answer
Hierarchal database table
SQL
1 vote114 views1 answer
Sql server today minus n
SQL
0 vote93 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote104 views1 answer
Sql date d'aujourd'hui
SQL