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 vote251 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
21 votes264 views6 answers
Docker run mysql
SQL
2 votes279 views3 answers
Mysql pass command from command line
SQL
0 vote311 views1 answer
Create table using the clause with as
SQL
0 vote262 views2 answers
Check mysql timezone
SQL
1 vote263 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote319 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote279 views1 answer
Mysql multiple group by
SQL
0 vote261 views1 answer
Mysql trim characters
SQL
3 votes256 views1 answer
Difference sql vs mysql
SQL