Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql user permission database

GRANT ALL PRIVILEGES ON `db_name`.* TO 'user'@'host'
Comment

mysql permissions

GRANT SELECT, UPDATE, INSERT, DELETE ON `db_name`.* TO 'user'@'localhost';
Comment

mysql grant user permissions

-- create user if not exists
-- CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';");

-- grant all user permissions on all database and tables
-- GRANT ALL ON *.* TO 'username'@'localhost'");

-- create specific database
-- CREATE DATABASE newdatabase

-- grant all user permissions on db 'newdatabase' and all tables
-- GRANT ALL ON newdatabase.* TO 'username'@'localhost'");

-- grant all user permissions on db 'newdatabase' and table 'newtable'
-- GRANT ALL ON newdatabase.newtable TO 'username'@'localhost'");
Comment

PREVIOUS NEXT
Code Example
Sql :: sql delete records older than 1 day 
Sql :: describe sql server 
Sql :: sql server list user permissions 
Sql :: mqtt Error: Address not available 
Sql :: oracle view source 
Sql :: tsql rename table 
Sql :: SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1 
Sql :: install mysql 8 ubuntu 18.04 
Sql :: mysql show tables in database 
Sql :: convert series number to date in sql 
Sql :: mysql int range 
Sql :: laravel paginate raw sql 
Sql :: postgresql create table with boolean column 
Sql :: How Not To Sort By Average Rating 
Sql :: oracle current sequence value 
Sql :: psql import backup file for windows 
Sql :: SQL query to convert DD/MM/YYYY to YYYY-MM-DD 
Sql :: sql myisam vs innodb 
Sql :: oracle new column 
Sql :: sql replace character in string in all records 
Sql :: how to delete git repo locally 
Sql :: add new column not null sql server 
Sql :: mysql how to subtract dates 
Sql :: backup postgres database 
Sql :: sql like 
Sql :: how to export table data from mysql table in sql format 
Sql :: random record using order by rand() mysql 
Sql :: sqlserver docker 
Sql :: sql query to search for a string in all columns 
Sql :: ubuntu reset mysql root password 
ADD CONTENT
Topic
Content
Source link
Name
7+6 =