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 vote391 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
1 vote341 views1 answer
Select last row from SQL Table
SQL
0 vote273 views1 answer
Ms sql print more than 1 variable
SQL
4 votes315 views1 answer
Mysql insert from local csv
SQL
-1 vote312 views2 answers
On delete set default sql server
SQL
0 vote337 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
-1 vote342 views1 answer
Sql show custom constraints
SQL
0 vote344 views1 answer
Sql alter table add column if exists
SQL
-1 vote348 views1 answer
How to change the auto increment in existing table mysql
SQL
-1 vote349 views1 answer
Phinehas Psalm 106
SQL