/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 vote216 views1 answer
Select if then postgresql
SQL
0 vote211 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote215 views1 answer
How to query all tables mysql at the same time
SQL
0 vote218 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote238 views1 answer
Postgresql stored procedure update table values
SQL
1 vote206 views2 answers
How to check username in mysql command line
SQL
1 vote232 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote210 views3 answers
How to truncate table with foreign key constraint
SQL
1 vote215 views1 answer
Sql into vs insert into
SQL
1 vote289 views2 answers
Coderbyte sql solutions
SQL