Grant mysql

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 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 mydb.* TO 'myuser'@'%' WITH GRANT OPTION;

/*
I hope it will help you.
Namaste
*/

Mysql grant grant option

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

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

Source: oreilly.com

Similar codes

0 vote177 views1 answer
Mysql row generator
SQL
0 vote152 views1 answer
Mysql create table like
SQL
0 vote147 views1 answer
Mysql repair a table
SQL
0 vote145 views1 answer
Sql developer search all packages for text
SQL
10 votes184 views2 answers
Reset mysql root password mac
SQL
0 vote142 views2 answers
Sqlite unique
SQL
2 votes156 views1 answer
Mysql change data type of column
SQL
0 vote145 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote149 views1 answer
Sql server alter table add column tinyint
SQL
0 vote148 views1 answer
Load utilities in sql server
SQL