/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 vote204 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote204 views1 answer
Power bi union columns
SQL
1 vote204 views1 answer
Mysql add fields
SQL
2 votes155 views1 answer
Latest record in sql
SQL
1 vote200 views1 answer
Postgres convert date to string
SQL
0 vote261 views1 answer
Regex mongoose
SQL
0 vote220 views1 answer
SELECT statement to find the specific cell in database table
SQL
6 votes189 views1 answer
Phpmyadmin password root
SQL
1 vote217 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote196 views1 answer
Query to get all primary keys and foreign key
SQL