/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

0 vote301 views1 answer
Sql alter column name sql server
SQL
1 vote282 views2 answers
Login to mysql
SQL
0 vote307 views1 answer
How to insert multiple values in a single column in sql
SQL
10 votes355 views4 answers
Sql server pagination
SQL
2 votes282 views2 answers
Oracle no data found error code
SQL
2 votes294 views2 answers
Created at and updated at in mysql
SQL
0 vote284 views1 answer
Get the previous column of a table in mysql
SQL
16 votes295 views1 answer
Mysql smallint range
SQL
0 vote295 views1 answer
Find usage of table in sql server
SQL
0 vote283 views1 answer
Restore backupfile discourse
SQL