Grant all privileges mysql

Mysql grant all privileges to a user

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Source: chartio.com

Grant all privileges mysql

/*
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 database_name.* TO 'username'@'localhost';

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
*/

Mysql user permission database

GRANT ALL PRIVILEGES ON `db_name`.* TO 'user'@'host'

Mysql grant grant option

GRANT ALL ON *.* TO 'user'@'localhost';

GRANT GRANT OPTION ON *.* TO 'user'@'localhost';

Source: oreilly.com

Similar codes

10 votes204 views4 answers
Else if mysql
SQL
2 votes172 views1 answer
Set username and password for postgresql database
SQL
0 vote123 views1 answer
How to connect sql server using ip address in c#
SQL
1 vote176 views1 answer
Sql try catch
SQL
0 vote161 views1 answer
Check psql validity function
SQL
1 vote309 views1 answer
Mysql data from file
SQL
1 vote182 views1 answer
Denied
SQL
4 votes178 views1 answer
Create column mysql terminal
SQL
0 vote208 views1 answer
Reindexing all tables sql server
SQL
1 vote178 views2 answers
Oracle create synonym
SQL