/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 votes265 views2 answers
Oracle grants
SQL
0 vote256 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote272 views1 answer
Setval in postgres
SQL
0 vote273 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
18 votes282 views3 answers
Get the list of all tables in sql server
SQL
0 vote277 views1 answer
What does leave do in mysql
SQL
0 vote251 views1 answer
How to connect to mysql in ef 6
SQL
0 vote259 views1 answer
Sql track modification
SQL
0 vote277 views2 answers
Raise notice in postgresql function
SQL
0 vote267 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL