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 vote264 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote263 views1 answer
Oracle activate job
SQL
1 vote300 views1 answer
Backup mysql schema only
SQL
0 vote276 views1 answer
Reindex mssql table
SQL
0 vote258 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote292 views1 answer
Oracle insert single quote in string
SQL
1 vote278 views2 answers
Maximum number of tables in mysql
SQL
0 vote255 views2 answers
Azure sql-datenbank
SQL
1 vote275 views1 answer
Wherein mysql
SQL
0 vote256 views1 answer
Sql server delete records with specific date
SQL