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 vote210 views2 answers
Sql select inside select
SQL
0 vote243 views1 answer
Change database name psql 8
SQL
1 vote241 views1 answer
Round function in sql oracle
SQL
4 votes230 views1 answer
Id primary key auto generated
SQL
-2 votes222 views1 answer
Create trigger syntax
SQL
1 vote227 views1 answer
Oracle create_program
SQL
1 vote259 views1 answer
Liquibase alter column type / length
SQL
4 votes234 views2 answers
Oracle unlock user
SQL
21 votes234 views5 answers
Oracle all tables
SQL
0 vote258 views1 answer
Sql basic commands
SQL