Search
 
SCRIPT & CODE EXAMPLE
 

SQL

grant all privileges mysql

/*
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 database_name.* TO 'username'@'localhost';
Comment

mysql privileges

create user admin@localhost identified by 'admin123';
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle kill sessions script 
Sql :: sql query for displaying age from oldest to youngest 
Sql :: how to modify alter user root@localhost identified with mysql_native_password by properly 
Sql :: postgres execute multiple sql file from command line 
Sql :: select columns from 2 tables with foreign key 
Sql :: sql ignore 
Sql :: creating database with - 
Sql :: sql reverse 
Sql :: drop constraint in ms sql 
Sql :: sql update subtract value 
Sql :: oracle sql distinct vs unique 
Sql :: mysql ddl 
Sql :: sql server port number 
Sql :: like in sql 
Sql :: inner join vs outer join 
Sql :: sql server port 1434 
Sql :: group_concat sql server 
Sql :: mysql backup certain tables workbench 
Sql :: round decimal mysql 
Sql :: fuck docker mysql 
Sql :: mysql case sensitive ? 
Sql :: hou to run job from cmd .exe sql server jop 
Sql :: edad en oracle 
Sql :: trigger stock phpmyadmin 
Sql :: datetrunc hour snowflake 
Sql :: create relationship with betwen two tables in postgersql 
Sql :: mysql aspas simples 
Sql :: Original Query 
Sql :: downgrading sql localdb visual studio 
Sql :: phpmyadmin tabellentyp ändern 
ADD CONTENT
Topic
Content
Source link
Name
1+6 =