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

7 votes113 views4 answers
Lowest salary in sql
SQL
6 votes121 views3 answers
Mysql first day of year
SQL
1 vote121 views1 answer
Print all records of table in mysql
SQL
0 vote118 views1 answer
What is SQL data store?
SQL
0 vote106 views1 answer
Minus equivalent in my sql
SQL
2 votes114 views1 answer
Pandas to sql index
SQL
8 votes127 views10 answers
Sql
SQL
0 vote119 views1 answer
Mariadb mysql root access denied
SQL
0 vote118 views1 answer
Find and replace query in wordpress\
SQL
1 vote123 views1 answer
Name of today sql
SQL