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

4 votes319 views2 answers
Oracle unlock user
SQL
4 votes317 views2 answers
Postgre sql create table
SQL
0 vote319 views1 answer
ORA-00942
SQL
0 vote314 views1 answer
Mysql query problems and solutions
SQL
0 vote322 views1 answer
Sql select where more than one record exists
SQL
1 vote310 views1 answer
Sql query row number group by
SQL
49 votes391 views6 answers
Mysql add column to table
SQL
11 votes345 views4 answers
Update row in mysql
SQL
0 vote309 views1 answer
Drop all tables db2
SQL
0 vote297 views1 answer
Trim sql oracle
SQL