/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 vote151 views1 answer
Command line mysql xampp
SQL
0 vote114 views1 answer
Mysql sleep connections
SQL
0 vote145 views1 answer
Query for backup a database at another location in file system
SQL
2 votes125 views4 answers
Duplicate record mysql
SQL
2 votes124 views1 answer
Sql update alias
SQL
0 vote211 views1 answer
Add user mysql wordpress
SQL
0 vote129 views1 answer
Assign value to var in SQL
SQL
1 vote133 views1 answer
Oracle get current schema
SQL
2 votes139 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
3 votes137 views1 answer
Null sql
SQL