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

1 vote299 views1 answer
Mysql is odd
SQL
0 vote221 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
1 vote223 views1 answer
Postgres install unaccent extension
SQL
1 vote227 views4 answers
How to check table in postgresql from terminal
SQL
0 vote197 views1 answer
Mysql in clausule string array
SQL
24 votes203 views2 answers
Alter table delete column
SQL
0 vote202 views1 answer
Sql case when exists in another table
SQL
0 vote187 views2 answers
Get top 1 row of each group
SQL
6 votes197 views1 answer
Phpmyadmin reset root password
SQL
50 votes315 views6 answers
Sql count duplicate rows
SQL