/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

7 votes177 views1 answer
Xampp reset mysql
SQL
0 vote167 views1 answer
Como hacer una consulta en sql
SQL
0 vote162 views1 answer
Oracle list dblink
SQL
20 votes190 views3 answers
Update values in select statement sql
SQL
5 votes189 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote170 views1 answer
Get who is hired in month in sql
SQL
0 vote177 views1 answer
Data directory postgresql
SQL
0 vote352 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote181 views2 answers
Raise notice in postgresql function
SQL
0 vote170 views1 answer
Is numeric in sql
SQL