/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 vote148 views1 answer
Empty table sqlite
SQL
0 vote148 views1 answer
Psql generate id in existing database
SQL
0 vote126 views5 answers
Sql table intermédiaire
SQL
0 vote137 views1 answer
Get current date data in mysql
SQL
0 vote144 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote152 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote143 views1 answer
Postgres sql alter table delete row
SQL
0 vote159 views1 answer
Savepoint mysql script
SQL
0 vote131 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote133 views1 answer
Sql server whoami
SQL