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 vote321 views1 answer
Create table with timestamp mysql youtube
SQL
6 votes330 views3 answers
Date_trunc postgres
SQL
1 vote331 views1 answer
Sql server epoch to datetime
SQL
1 vote384 views1 answer
Sql select row with max date
SQL
0 vote330 views1 answer
How to use group_concat in sql server
SQL
0 vote321 views1 answer
How to combine rows in sql server procedure
SQL
0 vote335 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote328 views1 answer
Postgresql function ROUND
SQL
1 vote319 views1 answer
Postgresql transaction discard all
SQL
3 votes354 views3 answers
Mysql declare variable
SQL