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 vote200 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
1 vote186 views1 answer
Postgresql blocked on mac
SQL
0 vote185 views1 answer
Sql trying to delete database in use
SQL
23 votes174 views6 answers
Delete all rows from table sql
SQL
0 vote209 views1 answer
Distance calculator from lat long sql query
SQL
0 vote173 views2 answers
Sql searching via key word
SQL
0 vote173 views1 answer
In mysql workbench contnent not feching
SQL
1 vote186 views1 answer
Delete specific row in sql
SQL
0 vote177 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
11 votes188 views1 answer
Creating tables in sql with python
SQL