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 vote175 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
2 votes140 views1 answer
Get hour from date sql
SQL
1 vote89 views1 answer
Python escape string for sql
SQL
0 vote200 views1 answer
Oracle sql all days except weekends
SQL
1 vote126 views1 answer
Nested if in mysql
SQL
0 vote142 views1 answer
Oracle string substitution
SQL
0 vote134 views2 answers
Select columns from 2 tables with foreign key
SQL
1 vote140 views3 answers
String to int mysql
SQL
4 votes152 views1 answer
Postgresql create table with index
SQL
9 votes138 views6 answers
Sql insert into
SQL