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 vote158 views1 answer
Mysql order by rand limit 1 really slow
SQL
2 votes134 views1 answer
Ifnull postgres
SQL
6 votes141 views1 answer
Phpmyadmin reset root password
SQL
32 votes163 views6 answers
How to change column name in sql
SQL
7 votes132 views1 answer
Safe mode mysql
SQL
0 vote153 views1 answer
Mysql where in keep order
SQL
0 vote161 views1 answer
Sql delete dastabase
SQL
0 vote160 views1 answer
Create table in dbms cmds
SQL
0 vote142 views1 answer
Restart sql server command line linux
SQL
2 votes203 views2 answers
Mysql date range
SQL