Sql

Search

mysql grant access to one database

//create the user:
CREATE USER 'user'@'hostname' IDENTIFIED BY 'password';

//give it access to the database dbTest
GRANT ALL PRIVILEGES ON dbTest.* To 'user'@'hostname' ;

Comment

PREVIOUS	NEXT

Code Example
Sql :: duplicate records in sql
Sql :: mysql select tables with name like
Sql :: change database name psql 8
Sql :: psql fatal database does not exist
Sql :: sql count null
Sql :: how to change column name in sql
Sql :: print year of a date sql
Sql :: @sqlresultsetmapping
Sql :: sql date diff
Sql :: postgresql casting integer to string
Sql :: postgresql export database
Sql :: vbscript connect mssql
Sql :: oracle create table if not exists
Sql :: sql alter type of column
Sql :: delete join select from one table based on multiple values
Sql :: create table employees oracle
Sql :: show the colums of table sql
Sql :: pl/sql procedure example
Sql :: mysql ip address data type
Sql :: postgre sql create table
Sql :: events mysql
Sql :: left join in codeigniter query builder
Sql :: mariadb hours between two dates
Sql :: duplicate entry
Sql :: postgresql create role
Sql :: sql count null as 0
Sql :: output table plsql
Sql :: mssql dockere
Sql :: postgres duplicate key value violates unique constraint already exists
Sql :: show query code after create table in sql

Search

SQL

mysql grant access to one database

ADD CONTENT