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

0 vote184 views1 answer
Compare field sql server
SQL
8 votes173 views1 answer
Oracle create datafile
SQL
0 vote180 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
5 votes163 views1 answer
Sql first day of current year
SQL
2 votes201 views1 answer
Postgresql group by month and year
SQL
0 vote175 views1 answer
Create table in dbms cmds
SQL
0 vote153 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote155 views1 answer
Oracle index hint multiple tables example
SQL
7 votes189 views1 answer
Buy forge mods server hosting
SQL
0 vote183 views1 answer
Update sql sintax
SQL