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 votes151 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
12 votes117 views4 answers
Mysql get date difference in hours
SQL
0 vote132 views1 answer
Sql column contains special character
SQL
29 votes117 views6 answers
Delete all rows from table mysql
SQL
1 vote130 views1 answer
Declare variables sql
SQL
0 vote133 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote139 views1 answer
Psql check table fields
SQL
5 votes147 views2 answers
Mysql create database charset utf8mb4
SQL
2 votes190 views1 answer
Oracle list grants on package
SQL
0 vote127 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL