/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 vote410 views1 answer
How to get button for every record from mysql
SQL
7 votes347 views4 answers
Database dump mysql command
SQL
0 vote349 views2 answers
How to start postgresql laravel
SQL
0 vote365 views1 answer
Sql convert float to string
SQL
2 votes352 views1 answer
Brew start postgres manual
SQL
11 votes398 views5 answers
Laravel db facade
SQL
0 vote380 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote387 views1 answer
Creating sqeuence in oracle database
SQL
0 vote356 views1 answer
Incorrect datetime value sql table error 1292
SQL
24 votes401 views6 answers
Replace mysql
SQL