/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

1 vote296 views1 answer
Create temporal table in sql
SQL
3 votes292 views4 answers
Show columns from table
SQL
0 vote301 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote319 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote324 views1 answer
Sqlalchemy empty table
SQL
0 vote316 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
10 votes310 views1 answer
User_dependencies
SQL
26 votes305 views2 answers
What is the sql statement that finds duplicate usernames
SQL
8 votes292 views3 answers
Alter table auto_increment
SQL
0 vote326 views1 answer
Possgress drop if exists view
SQL