/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 vote194 views3 answers
Get all tables postgres
SQL
15 votes209 views4 answers
Pl sql
SQL
0 vote246 views2 answers
Search stored procedures
SQL
0 vote200 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote191 views1 answer
Postgre admin slow
SQL
1 vote197 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote187 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
5 votes290 views4 answers
Sql check
SQL
0 vote195 views1 answer
Oracle query to see what scema i am working in
SQL
1 vote241 views1 answer
How to give access to database in postgresql server to another user
SQL