/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 vote186 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
2 votes160 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote185 views1 answer
Casterar postgres
SQL
4 votes166 views1 answer
Sql any
SQL
103 votes2.4K views1 answer
Like sql
SQL
3 votes237 views1 answer
Mysql group_concat distinct
SQL
11 votes167 views1 answer
Oracle view ddl
SQL
0 vote175 views1 answer
Write sql query to show the details start from digit
SQL
0 vote189 views1 answer
Connect to ssms with python
SQL
0 vote173 views2 answers
Sql server set default value equal to auto increment
SQL