mysql_scripts.sql 481 B

123456789101112
  1. CREATE DATABASE IF NOT EXISTS fd_session;
  2. CREATE TABLE IF NOT EXISTS `fd_session`.`sessions` (
  3. `sess_id` varchar(128) COLLATE utf8_bin NOT NULL,
  4. `sess_data` longtext COLLATE utf8_bin NOT NULL,
  5. `sess_time` int(10) unsigned NOT NULL,
  6. `sess_lifetime` mediumint(9) NOT NULL,
  7. PRIMARY KEY (`sess_id`)
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  9. GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY '#password#';
  10. GRANT ALL ON *.* TO 'iksop'@'%' IDENTIFIED BY '#password#';