/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 vote273 views2 answers
Insert data mysql with cmd
SQL
0 vote218 views1 answer
How to check replication lag in mySQL
SQL
0 vote259 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote247 views1 answer
Hibernate show sql xml property
SQL
1 vote215 views1 answer
Foreign key constraint in ms sql
SQL
0 vote246 views1 answer
Postgres sequence name
SQL
0 vote270 views2 answers
Temp tables in sql server
SQL
4 votes257 views1 answer
Mysql store ip address
SQL
5 votes224 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote226 views1 answer
Opensuse stop MySQL
SQL