/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 vote345 views1 answer
Change magento database url usimg musql
SQL
32 votes358 views6 answers
Sql count where
SQL
0 vote344 views1 answer
Mysql where in keep order
SQL
0 vote378 views1 answer
How to inner join 4 tables in sql
SQL
1 vote372 views1 answer
Get current date in pyspark sql
SQL
1 vote311 views1 answer
Full text index mysql
SQL
3 votes348 views1 answer
Oracle drop user
SQL
0 vote356 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
1 vote327 views1 answer
Postgres count string length
SQL
0 vote389 views1 answer
New rails app with mysql
SQL