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 vote178 views1 answer
Postgresql if else endif
SQL
0 vote189 views2 answers
Jsonb
SQL
1 vote199 views1 answer
Pentaho + pasar de excel a sql
SQL
1 vote228 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
1 vote167 views2 answers
T sql get foreign key
SQL
2 votes191 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote176 views1 answer
Sql missing values
SQL
20 votes183 views4 answers
Reset auto increment in MySQL
SQL
7 votes168 views4 answers
Lowest salary in sql
SQL
0 vote159 views1 answer
Check if a word appears at the end sql query
SQL