· 7 years ago · Jan 22, 2019, 10:18 AM
1Aborted connection 40 to db: 'db_16001' user: 'xxx@outlook.com' host: 'localhost' (init_connect command failed)
2
3CREATE DATABASE IF NOT EXISTS `db_16001` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
4
5USE `db_16001`;
6CREATE TABLE `aboneler` (
7`abone_id` int(11) NOT NULL,
8`ad_soyad` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
9`telefon` varchar(13) COLLATE utf8_unicode_ci DEFAULT NULL,
10`e_posta` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
11`sifre` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
12`yonetici` bit(1) NOT NULL DEFAULT b'0',
13 PRIMARY KEY(`abone_id`)
14) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;
15
16CREATE USER 'xxx@outlook.com'@'localhost' IDENTIFIED BY 'password';
17GRANT EXECUTE, INSERT, UPDATE, DELETE, SELECT, GRANT OPTION ON `db_16001`.* TO 'xxx@outlook.com'@'localhost';
18FLUSH PRIVILEGES;