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 vote209 views1 answer
Time data type in mysql
SQL
0 vote183 views1 answer
Mysql to get column name in database
SQL
0 vote194 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote194 views1 answer
Mariadb errno 121
SQL
0 vote210 views1 answer
Reset postgres table index to next max value
SQL
0 vote211 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote201 views3 answers
Remove folders from remote git
SQL
1 vote187 views2 answers
Setval max id postgresql sequence
SQL
0 vote185 views1 answer
Oracle db get table sizes
SQL
0 vote195 views1 answer
Gcloud sql instance list
SQL