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

17 votes247 views4 answers
Sort by mysql
SQL
3 votes242 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
5 votes245 views2 answers
Oracle list columns
SQL
0 vote262 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote249 views1 answer
Normalization in database
SQL
0 vote258 views2 answers
Sql day from datetime
SQL
0 vote241 views1 answer
Sql cnvert bit to nvarchar
SQL
4 votes314 views2 answers
Delete all table oracle
SQL
3 votes259 views2 answers
How to force truncate a table in mysql
SQL
1 vote255 views1 answer
Name of today sql
SQL