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

3 votes330 views1 answer
Sql datetime as date
SQL
13 votes336 views2 answers
Sql join
SQL
0 vote327 views1 answer
Concat column value of same user in mysql
SQL
-1 vote304 views1 answer
How to format tables in sqlplus
SQL
4 votes480 views6 answers
Laravel jwt
SQL
1 vote353 views1 answer
SQL query to get all table records count from a database
SQL
0 vote316 views1 answer
Get duplicate entry sql
SQL
1 vote349 views1 answer
Oracle undo usage per session
SQL
0 vote378 views1 answer
Error code 1451 sql
SQL
0 vote345 views1 answer
Where field is null sql knex
SQL