/SQL/Grant all priviledges to mysql user

Grant all priviledges to mysql user

Mysql grant all privileges to a user

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Source: chartio.com

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
*/

Similar codes

3 votes324 views3 answers
Start postgresql ubuntu
SQL
1 vote311 views2 answers
Mysql join two tables
SQL
0 vote346 views1 answer
Influxdb list all tags for a measurement
SQL
7 votes328 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote342 views1 answer
Get clob size oracle
SQL
9 votes303 views6 answers
Sql insert into
SQL
0 vote283 views1 answer
Oracle list all stored procedures
SQL
5 votes322 views2 answers
Mysql import gzip db
SQL
2 votes319 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote336 views1 answer
How to take sum of column with same id in "JPQL?"
SQL