/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 vote106 views1 answer
Md5 encryption for existing records
SQL
0 vote121 views1 answer
Define a variable in mysql from select
SQL
2 votes108 views1 answer
Add new column not null sql server
SQL
0 vote108 views2 answers
How to know the character set of an oracle databes
SQL
0 vote108 views1 answer
Oracle array
SQL
1 vote95 views1 answer
Oracle finding duplicate records
SQL
0 vote109 views1 answer
Oracle table privileges
SQL
15 votes108 views3 answers
Mysql update add to existing value
SQL
6 votes109 views3 answers
Check if string contains substring sql
SQL
1 vote115 views1 answer
Postgresql define pk sequence next number
SQL