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 vote159 views1 answer
Permission denied postgres \copy csv command line
SQL
11 votes317 views4 answers
Round in sql
SQL
1 vote157 views1 answer
Mysql search like order by best match
SQL
8 votes145 views1 answer
Oracle tablespace datafile max size
SQL
0 vote140 views1 answer
Oracle service name view
SQL
11 votes159 views3 answers
Sql line numbers
SQL
0 vote150 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
11 votes153 views5 answers
Sql server reset identity
SQL
0 vote177 views1 answer
DATEDIFF minute postgres
SQL
0 vote145 views2 answers
Import .sql into postgres db command
SQL