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 vote192 views1 answer
Show the colums of table sql
SQL
0 vote197 views1 answer
Limit in access query
SQL
-1 vote207 views1 answer
Add bool column in sql
SQL
0 vote202 views1 answer
How to move a column to different spot mysql
SQL
7 votes206 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote190 views1 answer
We are intrested to work with your organization
SQL
0 vote212 views1 answer
Including parameters in OPENQUERY
SQL
1 vote185 views1 answer
Postgres check for foreign key
SQL
0 vote192 views1 answer
Mssql now diff 90 day
SQL
4 votes196 views1 answer
Mysql not equal
SQL