/SQL/Grant all priviledges to mysql user

Grant all priviledges to mysql user

Mysql grant all privileges to a user

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Source: chartio.com

Grant all priviledges to mysql user

/*
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
*/

Similar codes

0 vote96 views1 answer
Nth max in my sql
SQL
1 vote113 views1 answer
How to unlock table in mysql
SQL
0 vote90 views2 answers
How to start postgresql laravel
SQL
0 vote100 views1 answer
Sum values by month mariadb
SQL
3 votes119 views3 answers
Update con select postgresql
SQL
0 vote134 views1 answer
Restart serial number for postgres
SQL
1 vote113 views1 answer
How to truncate a table in databse
SQL
0 vote97 views1 answer
Oracle activate program
SQL
0 vote142 views1 answer
Sql server datetime
SQL
0 vote110 views1 answer
How to select even id in sql
SQL