SQL 22 dec

CREATE USER 'lietotajvards'@'hosts'; => hosts adrese no kurieniem vinš varēs piekļūt, ar tukšu paroli.

CREATE USER 'lietotajvards'@'%';      => jebkurš hosts, ar tukšu paroli.

CREATE USER 'lietotajvards'@'%' IDENTIFIED BY 'pamspamparam'; parole 

CREATE USER 'lietotajvards1'@'%' IDENTIFIED BY '1';

GRANT ALL ON *.* TO 'lietotajs'@'hosts'; => piekļūve visām datubāzēm

GRANT ALL ON `datubaze`.* TO 'lietotajs'@'hosts'; visam tabulam datubāzē 'datubaze'

GRANT ALL ON `datubaze`.`tabula` TO 'lietotajs'@'hosts'; tabula tabula datubzē datubaze

GRANT ALL (`kolonna1`,`kolonna2`) ON `datubaze`.`tabula` TO 'lietotajs'@'hosts';

GRANT UPDATE (`kolonna1`,`kolonna2`), DELETE (`kolonna3`) ON `datubaze`.`tabula` TO 'lietotajs'@'hosts';

GRANT UPDATE (`kolonna1`,`kolonna2`), DELETE (`kolonna3`) ON `datubaze`.`tabula` TO 'lietotajs'@'hosts' IDENTYFIED BY '';

GRANT UPDATE (`kolonna1`,`kolonna2`), DELETE (`kolonna3`) ON `datubaze`.`tabula` TO 'lietotajs'@'hosts' WITH GRANT_OPTION; - drīkst piešķirt tiesības citam lietotājām

MAX_QUERIES_PER_HOUR

MAX_UPDATES_PER_HOUR

MAX_CONNECTIONS_PER_HOUR

MAX_USER_CONNECTIONS - limits cik savienojumi atļauti vienlaikus

GRANT UPDATE (`kolonna1`,`kolonna2`), DELETE (`kolonna3`) ON `datubaze`.`tabula` TO 'lietotajs'@'hosts' WITH MAX_USER_CONNECTIONS 100;

GRANT ALL ON datubaze.tabula TO 'lietotajs1'@'hosts';

CREATE DATABASE database_name1  
USE `database_name1`;
 CREATE TABLE customer (First_Name char(50), Last_Name char(50), Address char(50), City char(50), Country char(25), Birth_Date date)  CREATE USER 'lietotajvards5'@'%' IDENTIFIED BY '123';  GRANT ALL ON `database_name1`.* TO 'lietotajvards5'@'%';

------------------------

CREATE DATABASE `newdb`;

 
USE `newdb`;
 CREATE TABLE `testtable` ( `id` INT(42), `user` TEXT, `pass` VARCHAR(10) NOT NULL, PRIMARY KEY(`id`) ); CREATE USER 'user1'@'localhost' IDENTIFIED BY 'usersstrongpass'; GRANT ALL ON `newdb`.`testtable` TO 'user1'@'localhost';

-----------------------

CREATE DATABASE `testuser`;

 
USE `testuser`;
 CREATE TABLE `testuser`.`testabc` ( 	`id` INT(10) NOT NULL AUTO_INCREMENT, 	`name` TEXT NULL, 	`email` TEXT NULL, 	`text` TEXT NULL, 	`ip` CHAR(15) NULL DEFAULT NULL, 	`time` INT(64) NULL DEFAULT NULL, 	PRIMARY KEY (`id`) ) COMMENT='TestABC' COLLATE='utf8_general_ci' ENGINE=MyISAM ROW_FORMAT=DEFAULT AUTO_INCREMENT=10; CREATE USER 'antonrabc'@'localhost' IDENTIFIED BY PASSWORD '*0987E8574CF180AEF538D830668D5050DDA62874'; GRANT ALL ON `testuser`.`testabc` TO 'antonrabc'@'localhost'; 

-------------------------------

 CREATE DATABASE `newuserdb`;  USE `newuserdb`;  CREATE TABLE `user1table` ( `id` INT(42), `text` TEXT, `what` VARCHAR(10), PRIMARY KEY(`id`) );  CREATE USER 'user1'@'localhost' IDENTIFIED BY 'guga'; GRANT ALL ON `newuserdb`.`user1table` TO 'user1'@'localhost';

-------------------------------

USE `mysql`;  SELECT * FROM `newuserdb`.`user1table`;

-------------------------------

SELECT DATABASE();

-------------------------------

SHOW DATABASES;

-------------------------------