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

12 votes148 views1 answer
Psql drop column
SQL
0 vote148 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote158 views1 answer
How to use lower case in mysql
SQL
0 vote231 views1 answer
Install ms sql server management studio
SQL
0 vote154 views1 answer
Mysqlimport
SQL
0 vote146 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote142 views1 answer
Oracle list proxy users
SQL
16 votes141 views1 answer
Mysql mediumint max value
SQL
0 vote166 views1 answer
Show all sequences postgres
SQL
0 vote156 views1 answer
Mysql update set sum
SQL