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

19 votes226 views3 answers
How to change column type psql
SQL
12 votes239 views4 answers
How to drop all tables in postgresql
SQL
18 votes202 views6 answers
Mysql create table
SQL
8 votes201 views1 answer
Insert a select statement into a table
SQL
2 votes194 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote199 views1 answer
Excute raw query
SQL
3 votes204 views3 answers
Create table in microsoft sql server
SQL
4 votes196 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
8 votes219 views3 answers
Postgres database sizes
SQL
3 votes169 views1 answer
Postgresql where current year
SQL