/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

1 vote120 views1 answer
Show structure of table in sql
SQL
0 vote113 views1 answer
Mysql change innodb to myisam
SQL
0 vote123 views1 answer
Where field is null sql knex
SQL
16 votes133 views5 answers
Select last row in sql
SQL
0 vote122 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
3 votes140 views3 answers
Mysql auto increment after delete
SQL
10 votes127 views4 answers
How to alter table name in mysql
SQL
0 vote114 views2 answers
Mysql disable foreign key checks
SQL
0 vote121 views1 answer
Mysql Selected All Duplicate Rows
SQL
1 vote108 views1 answer
Temp table vs variable table in sql server
SQL