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 vote131 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote150 views1 answer
Find wordpress version in database
SQL
0 vote152 views1 answer
Mysql join only one column
SQL
3 votes131 views1 answer
Sql double index
SQL
0 vote126 views1 answer
1 column values in to 1 single row in sql
SQL
1 vote133 views1 answer
Altrer name column postgres
SQL
0 vote126 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote136 views2 answers
How to display enum value sql server
SQL
3 votes131 views2 answers
Truncate all tables
SQL
0 vote130 views2 answers
Postgresql get last day of month
SQL