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

1 vote191 views1 answer
Pl sql create table from another table
SQL
0 vote179 views1 answer
Database timezone
SQL
0 vote177 views1 answer
Mysql create table like
SQL
4 votes181 views1 answer
T-sql get duplicate rows
SQL
0 vote178 views1 answer
Oracle free up space in tablespace
SQL
0 vote176 views1 answer
Update view sql
SQL
0 vote249 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote193 views1 answer
Second Step in installing SQL workbench
SQL
1 vote187 views3 answers
Union in sql
SQL
0 vote156 views1 answer
Postgres create database if not exists
SQL