Sql

Search

mysql grant all privileges to a user

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Comment

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
*/

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql if null then 0
Sql :: get monday of current week sql
Sql :: SQLite order random
Sql :: installing postgresql ubuntu
Sql :: oracle show execution plan
Sql :: mysql safe mode
Sql :: sql server cannot create database diagram
Sql :: check database status oracle
Sql :: désinstaller postgresql linux
Sql :: where clause for child record apex
Sql :: sql server date format dd/mm/yyyy
Sql :: insert if not exists postgresql
Sql :: oracle exceeded simultaneous sessions_per_user limit
Sql :: check postgresql port windows
Sql :: mysql alter table modify column
Sql :: purge undo tablespace oracle 11g
Sql :: oracle invalid table name
Sql :: mysql select another database
Sql :: oracle list duplicates
Sql :: sql select sum group by id laravel join
Sql :: sql delete caracter list
Sql :: postgresql search object in array
Sql :: mysql add root password
Sql :: mysql select if empty result
Sql :: mysql how to store lat,lng
Sql :: change column name sql server management studio
Sql :: sql server update to null
Sql :: sql merge
Sql :: display 2 numbers after decimal mysql
Sql :: mysql where value is null

Search

SQL

mysql grant all privileges to a user

grant all priviledges to mysql user

ADD CONTENT