/usr/sbin/mysqld, Version: 5.0.22-Debian_0ubuntu6.06.3-log. started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 070322 21:11:24 1 Connect debian-sys-maint@localhost on 1 Quit 2 Connect debian-sys-maint@localhost on 2 Quit 3 Connect debian-sys-maint@localhost on 3 Query show /*!40003 GLOBAL */ variables 3 Quit 070322 21:11:25 4 Connect debian-sys-maint@localhost on mysql 4 Query set storage_engine=MyISAM 4 Query CREATE TABLE IF NOT EXISTS func ( name char(64) binary DEFAULT '' NOT NULL, ret tinyint(1) DEFAULT '0' NOT NULL, dl char(128) DEFAULT '' NOT NULL, type enum ('function','aggregate') COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (name) ) CHARACTER SET utf8 COLLATE utf8_bin 4 Query ALTER TABLE user add File_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL 4 Query SET @hadGrantPriv:=0 4 Query SELECT @hadGrantPriv:=1 FROM user WHERE Grant_priv LIKE '%' 4 Query ALTER TABLE user add Grant_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add References_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Index_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Alter_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL 4 Query ALTER TABLE host add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Index_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Alter_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL 4 Query ALTER TABLE db add Grant_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add References_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Index_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Alter_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL 4 Query UPDATE user SET Grant_priv=File_priv,References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0 4 Query UPDATE db SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0 4 Query UPDATE host SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0 4 Query ALTER TABLE user ADD ssl_type enum('','ANY','X509', 'SPECIFIED') COLLATE utf8_general_ci NOT NULL, ADD ssl_cipher BLOB NOT NULL, ADD x509_issuer BLOB NOT NULL, ADD x509_subject BLOB NOT NULL 4 Query ALTER TABLE user MODIFY ssl_type enum('','ANY','X509', 'SPECIFIED') NOT NULL 4 Query CREATE TABLE IF NOT EXISTS tables_priv ( Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Table_name char(64) binary DEFAULT '' NOT NULL, Grantor char(77) DEFAULT '' NOT NULL, Timestamp timestamp(14), Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') COLLATE utf8_general_ci DEFAULT '' NOT NULL, Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL, PRIMARY KEY (Host,Db,User,Table_name) ) CHARACTER SET utf8 COLLATE utf8_bin 4 Query ALTER TABLE tables_priv modify Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') COLLATE utf8_general_ci DEFAULT '' NOT NULL, modify Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL 4 Query ALTER TABLE procs_priv ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin 4 Query ALTER TABLE procs_priv modify Proc_priv set('Execute','Alter Routine','Grant') COLLATE utf8_general_ci DEFAULT '' NOT NULL 4 Query ALTER TABLE procs_priv add Routine_type enum('FUNCTION','PROCEDURE') COLLATE utf8_general_ci NOT NULL AFTER Routine_name 4 Query ALTER TABLE procs_priv modify Timestamp timestamp(14) AFTER Proc_priv 4 Query CREATE TABLE IF NOT EXISTS columns_priv ( Host char(60) DEFAULT '' NOT NULL, Db char(64) DEFAULT '' NOT NULL, User char(16) DEFAULT '' NOT NULL, Table_name char(64) DEFAULT '' NOT NULL, Column_name char(64) DEFAULT '' NOT NULL, Timestamp timestamp(14), Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL, PRIMARY KEY (Host,Db,User,Table_name,Column_name) ) CHARACTER SET utf8 COLLATE utf8_bin 4 Query ALTER TABLE columns_priv MODIFY Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL 4 Query ALTER TABLE columns_priv change Type Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL 4 Query ALTER TABLE func add type enum ('function','aggregate') COLLATE utf8_general_ci NOT NULL 4 Query SET @hadShowDbPriv:=0 4 Query SELECT @hadShowDbPriv:=1 FROM user WHERE Show_db_priv LIKE '%' 4 Query ALTER TABLE user ADD Show_db_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Alter_priv, ADD Super_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Show_db_priv, ADD Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Super_priv, ADD Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_tmp_table_priv, ADD Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Lock_tables_priv, ADD Repl_slave_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Execute_priv, ADD Repl_client_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Repl_slave_priv 4 Query UPDATE user SET Show_db_priv= Select_priv, Super_priv=Process_priv, Execute_priv=Process_priv, Create_tmp_table_priv='Y', Lock_tables_priv='Y', Repl_slave_priv=file_priv, Repl_client_priv=File_priv where user<>"" AND @hadShowDbPriv = 0 4 Query ALTER TABLE user ADD max_questions int(11) NOT NULL DEFAULT 0 AFTER x509_subject, ADD max_updates int(11) unsigned NOT NULL DEFAULT 0 AFTER max_questions, ADD max_connections int(11) unsigned NOT NULL DEFAULT 0 AFTER max_updates 4 Query ALTER TABLE db ADD Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, ADD Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL 4 Query ALTER TABLE host ADD Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, ADD Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL 4 Query alter table user change max_questions max_questions int(11) unsigned DEFAULT 0 NOT NULL 4 Query alter table tables_priv add KEY Grantor (Grantor) 4 Query alter table db comment='Database privileges' 4 Query alter table host comment='Host privileges; Merged with database privileges' 4 Query alter table user comment='Users and global privileges' 4 Query alter table func comment='User defined functions' 4 Query alter table tables_priv comment='Table privileges' 4 Query alter table columns_priv comment='Column privileges' 4 Query ALTER TABLE user MODIFY Host char(60) NOT NULL default '', MODIFY User char(16) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin 4 Query ALTER TABLE user MODIFY Password char(41) character set latin1 collate latin1_bin NOT NULL default '', MODIFY Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Reload_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Shutdown_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Process_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY File_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Show_db_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Super_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Repl_slave_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Repl_client_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY ssl_type enum('','ANY','X509', 'SPECIFIED') COLLATE utf8_general_ci DEFAULT '' NOT NULL 4 Query ALTER TABLE db MODIFY Host char(60) NOT NULL default '', MODIFY Db char(64) NOT NULL default '', MODIFY User char(16) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin 4 Query ALTER TABLE db MODIFY Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL 4 Query ALTER TABLE host MODIFY Host char(60) NOT NULL default '', MODIFY Db char(64) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin 4 Query ALTER TABLE host MODIFY Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, MODIFY Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL 4 Query ALTER TABLE func ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin 4 Query ALTER TABLE func MODIFY type enum ('function','aggregate') COLLATE utf8_general_ci NOT NULL 4 Query ALTER TABLE columns_priv MODIFY Host char(60) NOT NULL default '', MODIFY Db char(64) NOT NULL default '', MODIFY User char(16) NOT NULL default '', MODIFY Table_name char(64) NOT NULL default '', MODIFY Column_name char(64) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin 4 Query ALTER TABLE columns_priv MODIFY Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL 4 Query ALTER TABLE tables_priv MODIFY Host char(60) NOT NULL default '', MODIFY Db char(64) NOT NULL default '', MODIFY User char(16) NOT NULL default '', MODIFY Table_name char(64) NOT NULL default '', MODIFY Grantor char(77) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin 4 Query ALTER TABLE tables_priv MODIFY Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') COLLATE utf8_general_ci DEFAULT '' NOT NULL, MODIFY Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL 070322 21:11:26 4 Query SET @hadCreateViewPriv:=0 4 Query SELECT @hadCreateViewPriv:=1 FROM user WHERE Create_view_priv LIKE '%' 4 Query ALTER TABLE db ADD Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Lock_tables_priv 4 Query ALTER TABLE host ADD Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Lock_tables_priv 4 Query ALTER TABLE user ADD Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Repl_client_priv 4 Query ALTER TABLE db ADD Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_view_priv 4 Query ALTER TABLE host ADD Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_view_priv 4 Query ALTER TABLE user ADD Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_view_priv 4 Query ALTER TABLE tables_priv MODIFY Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view') COLLATE utf8_general_ci DEFAULT '' NOT NULL 4 Query UPDATE user SET Create_view_priv=Create_priv, Show_view_priv=Create_priv where user<>"" AND @hadCreateViewPriv = 0 4 Query SET @hadCreateRoutinePriv:=0 4 Query SELECT @hadCreateRoutinePriv:=1 FROM user WHERE Create_routine_priv LIKE '%' 4 Query ALTER TABLE db ADD Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Show_view_priv 4 Query ALTER TABLE host ADD Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Show_view_priv 4 Query ALTER TABLE user ADD Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Show_view_priv 4 Query ALTER TABLE db ADD Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_routine_priv 4 Query ALTER TABLE host ADD Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_routine_priv 4 Query ALTER TABLE user ADD Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_routine_priv 4 Query ALTER TABLE db ADD Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Alter_routine_priv 4 Query ALTER TABLE host ADD Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Alter_routine_priv 4 Query UPDATE user SET Create_routine_priv=Create_priv, Alter_routine_priv=Alter_priv where user<>"" AND @hadCreateRoutinePriv = 0 4 Query UPDATE db SET Create_routine_priv=Create_priv, Alter_routine_priv=Alter_priv, Execute_priv=Select_priv where user<>"" AND @hadCreateRoutinePriv = 0 4 Query UPDATE host SET Create_routine_priv=Create_priv, Alter_routine_priv=Alter_priv, Execute_priv=Select_priv where @hadCreateRoutinePriv = 0 4 Query ALTER TABLE user ADD max_user_connections int(11) unsigned DEFAULT '0' NOT NULL AFTER max_connections 4 Query SET @hadCreateUserPriv:=0 4 Query SELECT @hadCreateUserPriv:=1 FROM user WHERE Create_user_priv LIKE '%' 4 Query ALTER TABLE user ADD Create_user_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Alter_routine_priv 4 Query UPDATE user LEFT JOIN db USING (Host,User) SET Create_user_priv='Y' WHERE @hadCreateUserPriv = 0 AND (user.Grant_priv = 'Y' OR db.Grant_priv = 'Y') 4 Query CREATE TABLE IF NOT EXISTS procs_priv ( Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Routine_name char(64) binary DEFAULT '' NOT NULL, Routine_type enum('FUNCTION','PROCEDURE') NOT NULL, Grantor char(77) DEFAULT '' NOT NULL, Proc_priv set('Execute','Alter Routine','Grant') COLLATE utf8_general_ci DEFAULT '' NOT NULL, Timestamp timestamp(14), PRIMARY KEY (Host,Db,User,Routine_name,Routine_type), KEY Grantor (Grantor) ) CHARACTER SET utf8 COLLATE utf8_bin comment='Procedure privileges' 4 Query CREATE TABLE IF NOT EXISTS help_topic ( help_topic_id int unsigned not null, name varchar(64) not null, help_category_id smallint unsigned not null, description text not null, example text not null, url varchar(128) not null, primary key (help_topic_id), unique index (name) ) CHARACTER SET utf8 comment='help topics' 4 Query CREATE TABLE IF NOT EXISTS help_category ( help_category_id smallint unsigned not null, name varchar(64) not null, parent_category_id smallint unsigned null, url varchar(128) not null, primary key (help_category_id), unique index (name) ) CHARACTER SET utf8 comment='help categories' 4 Query CREATE TABLE IF NOT EXISTS help_relation ( help_topic_id int unsigned not null references help_topic, help_keyword_id int unsigned not null references help_keyword, primary key (help_keyword_id, help_topic_id) ) CHARACTER SET utf8 comment='keyword-topic relation' 4 Query CREATE TABLE IF NOT EXISTS help_keyword ( help_keyword_id int unsigned not null, name varchar(64) not null, primary key (help_keyword_id), unique index (name) ) CHARACTER SET utf8 comment='help keywords' 4 Query CREATE TABLE IF NOT EXISTS time_zone_name ( Name char(64) NOT NULL, Time_zone_id int unsigned NOT NULL, PRIMARY KEY Name (Name) ) CHARACTER SET utf8 comment='Time zone names' 4 Query CREATE TABLE IF NOT EXISTS time_zone ( Time_zone_id int unsigned NOT NULL auto_increment, Use_leap_seconds enum('Y','N') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, PRIMARY KEY TzId (Time_zone_id) ) CHARACTER SET utf8 comment='Time zones' 4 Query ALTER TABLE time_zone MODIFY Use_leap_seconds enum('Y','N') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL 4 Query CREATE TABLE IF NOT EXISTS time_zone_transition ( Time_zone_id int unsigned NOT NULL, Transition_time bigint signed NOT NULL, Transition_type_id int unsigned NOT NULL, PRIMARY KEY TzIdTranTime (Time_zone_id, Transition_time) ) CHARACTER SET utf8 comment='Time zone transitions' 4 Query CREATE TABLE IF NOT EXISTS time_zone_transition_type ( Time_zone_id int unsigned NOT NULL, Transition_type_id int unsigned NOT NULL, Offset int signed DEFAULT 0 NOT NULL, Is_DST tinyint unsigned DEFAULT 0 NOT NULL, Abbreviation char(8) DEFAULT '' NOT NULL, PRIMARY KEY TzIdTrTId (Time_zone_id, Transition_type_id) ) CHARACTER SET utf8 comment='Time zone transition types' 4 Query CREATE TABLE IF NOT EXISTS time_zone_leap_second ( Transition_time bigint signed NOT NULL, Correction int signed NOT NULL, PRIMARY KEY TranTime (Transition_time) ) CHARACTER SET utf8 comment='Leap seconds information for time zones' 4 Query CREATE TABLE IF NOT EXISTS proc ( db char(64) collate utf8_bin DEFAULT '' NOT NULL, name char(64) DEFAULT '' NOT NULL, type enum('FUNCTION','PROCEDURE') NOT NULL, specific_name char(64) DEFAULT '' NOT NULL, language enum('SQL') DEFAULT 'SQL' NOT NULL, sql_data_access enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA' ) DEFAULT 'CONTAINS_SQL' NOT NULL, is_deterministic enum('YES','NO') DEFAULT 'NO' NOT NULL, security_type enum('INVOKER','DEFINER') DEFAULT 'DEFINER' NOT NULL, param_list blob DEFAULT '' NOT NULL, returns char(64) DEFAULT '' NOT NULL, body longblob DEFAULT '' NOT NULL, definer char(77) collate utf8_bin DEFAULT '' NOT NULL, created timestamp, modified timestamp, sql_mode set( 'REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE' ) DEFAULT '' NOT NULL, comment char(64) collate utf8_bin DEFAULT '' NOT NULL, PRIMARY KEY (db,name,type) ) engine=MyISAM character set utf8 comment='Stored Procedures' 4 Query ALTER TABLE proc MODIFY name char(64) DEFAULT '' NOT NULL, MODIFY specific_name char(64) DEFAULT '' NOT NULL, MODIFY sql_data_access enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA' ) DEFAULT 'CONTAINS_SQL' NOT NULL, MODIFY body longblob DEFAULT '' NOT NULL, MODIFY sql_mode set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE' ) DEFAULT '' NOT NULL, DEFAULT CHARACTER SET utf8 4 Query ALTER TABLE proc CONVERT TO CHARACTER SET utf8 4 Query ALTER TABLE proc MODIFY db char(64) collate utf8_bin DEFAULT '' NOT NULL, MODIFY definer char(77) collate utf8_bin DEFAULT '' NOT NULL, MODIFY comment char(64) collate utf8_bin DEFAULT '' NOT NULL 4 Query flush privileges 4 Quit 5 Connect debian-sys-maint@localhost on 5 Query SHOW DATABASES 5 Init DB mysql 5 Query SHOW TABLES 5 Query CHECK TABLE `columns_priv` FAST 5 Query CHECK TABLE `db` FAST 5 Query CHECK TABLE `func` FAST 5 Query CHECK TABLE `help_category` FAST 5 Query CHECK TABLE `help_keyword` FAST 5 Query CHECK TABLE `help_relation` FAST 5 Query CHECK TABLE `help_topic` FAST 5 Query CHECK TABLE `host` FAST 5 Query CHECK TABLE `proc` FAST 5 Query CHECK TABLE `procs_priv` FAST 5 Query CHECK TABLE `tables_priv` FAST 5 Query CHECK TABLE `time_zone` FAST 5 Query CHECK TABLE `time_zone_leap_second` FAST 5 Query CHECK TABLE `time_zone_name` FAST 5 Query CHECK TABLE `time_zone_transition` FAST 5 Query CHECK TABLE `time_zone_transition_type` FAST 5 Query CHECK TABLE `user` FAST 5 Init DB mythconverg 5 Query SHOW TABLES 5 Query CHECK TABLE `archiveitems` FAST 5 Query CHECK TABLE `callsignnetworkmap` FAST 5 Query CHECK TABLE `capturecard` FAST 5 Query CHECK TABLE `cardinput` FAST 5 Query CHECK TABLE `channel` FAST 5 Query CHECK TABLE `codecparams` FAST 5 Query CHECK TABLE `credits` FAST 5 Query CHECK TABLE `customexample` FAST 5 Query CHECK TABLE `diseqc_config` FAST 5 Query CHECK TABLE `diseqc_tree` FAST 5 Query CHECK TABLE `dtv_multiplex` FAST 5 Query CHECK TABLE `dtv_privatetypes` FAST 5 Query CHECK TABLE `dvdinput` FAST 5 Query CHECK TABLE `dvdtranscode` FAST 5 Query CHECK TABLE `eit_cache` FAST 5 Query CHECK TABLE `favorites` FAST 5 Query CHECK TABLE `filemarkup` FAST 5 Query CHECK TABLE `gallerymetadata` FAST 5 Query CHECK TABLE `gamemetadata` FAST 5 Query CHECK TABLE `gameplayers` FAST 5 Query CHECK TABLE `housekeeping` FAST 5 Query CHECK TABLE `inuseprograms` FAST 5 Query CHECK TABLE `jobqueue` FAST 5 Query CHECK TABLE `jumppoints` FAST 5 Query CHECK TABLE `keybindings` FAST 5 Query CHECK TABLE `keyword` FAST 5 Query CHECK TABLE `music_albums` FAST 5 Query CHECK TABLE `music_artists` FAST 5 Query CHECK TABLE `music_genres` FAST 5 Query CHECK TABLE `music_playlists` FAST 5 Query CHECK TABLE `music_smartplaylist_categories` FAST 5 Query CHECK TABLE `music_smartplaylist_items` FAST 5 Query CHECK TABLE `music_smartplaylists` FAST 5 Query CHECK TABLE `music_songs` FAST 5 Query CHECK TABLE `music_stats` FAST 5 Query CHECK TABLE `musicmetadata` FAST 5 Query CHECK TABLE `musicplaylist` FAST 5 Query CHECK TABLE `mythlog` FAST 5 Query CHECK TABLE `mythweb_sessions` FAST 5 Query CHECK TABLE `networkiconmap` FAST 5 Query CHECK TABLE `oldfind` FAST 5 Query CHECK TABLE `oldprogram` FAST 5 Query CHECK TABLE `oldrecorded` FAST 5 Query CHECK TABLE `people` FAST 5 Query CHECK TABLE `phonecallhistory` FAST 5 Query CHECK TABLE `phonedirectory` FAST 5 Query CHECK TABLE `pidcache` FAST 5 Query CHECK TABLE `playgroup` FAST 5 Query CHECK TABLE `profilegroups` FAST 5 Query CHECK TABLE `program` FAST 5 Query CHECK TABLE `programgenres` FAST 5 Query CHECK TABLE `programrating` FAST 5 Query CHECK TABLE `recgrouppassword` FAST 5 Query CHECK TABLE `record` FAST 5 Query CHECK TABLE `record_tmp` FAST 5 Query CHECK TABLE `recorded` FAST 5 Query CHECK TABLE `recordedcredits` FAST 5 Query CHECK TABLE `recordedmarkup` FAST 5 Query CHECK TABLE `recordedprogram` FAST 5 Query CHECK TABLE `recordedrating` FAST 5 Query CHECK TABLE `recordedseek` FAST 5 Query CHECK TABLE `recordingprofiles` FAST 5 Query CHECK TABLE `recordmatch` FAST 5 Query CHECK TABLE `romdb` FAST 5 Query CHECK TABLE `schemalock` FAST 5 Query CHECK TABLE `settings` FAST 5 Query CHECK TABLE `tvchain` FAST 070322 21:11:27 5 Query CHECK TABLE `videocategory` FAST 5 Query CHECK TABLE `videocountry` FAST 5 Query CHECK TABLE `videogenre` FAST 5 Query CHECK TABLE `videometadata` FAST 5 Query CHECK TABLE `videometadatacountry` FAST 5 Query CHECK TABLE `videometadatagenre` FAST 5 Query CHECK TABLE `videosource` FAST 5 Query CHECK TABLE `videotypes` FAST 5 Query CHECK TABLE `websites` FAST 5 Quit 070322 21:12:16 6 Connect mythtv@Microstar on 6 Query SET SESSION interactive_timeout=1000000 6 Query SELECT @@sql_mode 6 Query SET SESSION sql_mode='' 6 Query SET NAMES utf8 6 Query SHOW VARIABLES LIKE 'datadir' 6 Query SHOW VARIABLES LIKE 'log_error' 070322 21:12:19 6 Query show databases 070322 21:12:21 6 Init DB mythconverg 6 Query SHOW TABLE STATUS 6 Query SHOW INDEX FROM `archiveitems` 6 Query DESCRIBE `archiveitems` 6 Query SHOW INDEX FROM `callsignnetworkmap` 6 Query DESCRIBE `callsignnetworkmap` 6 Query SHOW INDEX FROM `capturecard` 6 Query DESCRIBE `capturecard` 6 Query SHOW INDEX FROM `cardinput` 6 Query DESCRIBE `cardinput` 6 Query SHOW INDEX FROM `channel` 6 Query DESCRIBE `channel` 6 Query SHOW INDEX FROM `codecparams` 6 Query DESCRIBE `codecparams` 6 Query SHOW INDEX FROM `credits` 6 Query DESCRIBE `credits` 6 Query SHOW INDEX FROM `customexample` 6 Query DESCRIBE `customexample` 6 Query SHOW INDEX FROM `diseqc_config` 6 Query DESCRIBE `diseqc_config` 6 Query SHOW INDEX FROM `diseqc_tree` 6 Query DESCRIBE `diseqc_tree` 6 Query SHOW INDEX FROM `dtv_multiplex` 6 Query DESCRIBE `dtv_multiplex` 6 Query SHOW INDEX FROM `dtv_privatetypes` 6 Query DESCRIBE `dtv_privatetypes` 6 Query SHOW INDEX FROM `dvdinput` 6 Query DESCRIBE `dvdinput` 6 Query SHOW INDEX FROM `dvdtranscode` 6 Query DESCRIBE `dvdtranscode` 6 Query SHOW INDEX FROM `eit_cache` 6 Query DESCRIBE `eit_cache` 6 Query SHOW INDEX FROM `favorites` 6 Query DESCRIBE `favorites` 6 Query SHOW INDEX FROM `filemarkup` 6 Query DESCRIBE `filemarkup` 6 Query SHOW INDEX FROM `gallerymetadata` 6 Query DESCRIBE `gallerymetadata` 6 Query SHOW INDEX FROM `gamemetadata` 6 Query DESCRIBE `gamemetadata` 6 Query SHOW INDEX FROM `gameplayers` 6 Query DESCRIBE `gameplayers` 6 Query SHOW INDEX FROM `housekeeping` 6 Query DESCRIBE `housekeeping` 6 Query SHOW INDEX FROM `inuseprograms` 6 Query DESCRIBE `inuseprograms` 6 Query SHOW INDEX FROM `jobqueue` 6 Query DESCRIBE `jobqueue` 6 Query SHOW INDEX FROM `jumppoints` 6 Query DESCRIBE `jumppoints` 6 Query SHOW INDEX FROM `keybindings` 6 Query DESCRIBE `keybindings` 6 Query SHOW INDEX FROM `keyword` 6 Query DESCRIBE `keyword` 6 Query SHOW INDEX FROM `music_albums` 6 Query DESCRIBE `music_albums` 6 Query SHOW INDEX FROM `music_artists` 6 Query DESCRIBE `music_artists` 6 Query SHOW INDEX FROM `music_genres` 6 Query DESCRIBE `music_genres` 6 Query SHOW INDEX FROM `music_playlists` 6 Query DESCRIBE `music_playlists` 6 Query SHOW INDEX FROM `music_smartplaylist_categories` 6 Query DESCRIBE `music_smartplaylist_categories` 6 Query SHOW INDEX FROM `music_smartplaylist_items` 6 Query DESCRIBE `music_smartplaylist_items` 6 Query SHOW INDEX FROM `music_smartplaylists` 6 Query DESCRIBE `music_smartplaylists` 6 Query SHOW INDEX FROM `music_songs` 6 Query DESCRIBE `music_songs` 6 Query SHOW INDEX FROM `music_stats` 6 Query DESCRIBE `music_stats` 070322 21:12:22 6 Query SHOW INDEX FROM `musicmetadata` 6 Query DESCRIBE `musicmetadata` 6 Query SHOW INDEX FROM `musicplaylist` 6 Query DESCRIBE `musicplaylist` 6 Query SHOW INDEX FROM `mythlog` 6 Query DESCRIBE `mythlog` 6 Query SHOW INDEX FROM `mythweb_sessions` 6 Query DESCRIBE `mythweb_sessions` 6 Query SHOW INDEX FROM `networkiconmap` 6 Query DESCRIBE `networkiconmap` 6 Query SHOW INDEX FROM `oldfind` 6 Query DESCRIBE `oldfind` 6 Query SHOW INDEX FROM `oldprogram` 6 Query DESCRIBE `oldprogram` 6 Query SHOW INDEX FROM `oldrecorded` 6 Query DESCRIBE `oldrecorded` 6 Query SHOW INDEX FROM `people` 6 Query DESCRIBE `people` 6 Query SHOW INDEX FROM `phonecallhistory` 6 Query DESCRIBE `phonecallhistory` 6 Query SHOW INDEX FROM `phonedirectory` 6 Query DESCRIBE `phonedirectory` 6 Query SHOW INDEX FROM `pidcache` 6 Query DESCRIBE `pidcache` 6 Query SHOW INDEX FROM `playgroup` 6 Query DESCRIBE `playgroup` 6 Query SHOW INDEX FROM `profilegroups` 6 Query DESCRIBE `profilegroups` 6 Query SHOW INDEX FROM `program` 6 Query DESCRIBE `program` 6 Query SHOW INDEX FROM `programgenres` 6 Query DESCRIBE `programgenres` 6 Query SHOW INDEX FROM `programrating` 6 Query DESCRIBE `programrating` 6 Query SHOW INDEX FROM `recgrouppassword` 6 Query DESCRIBE `recgrouppassword` 6 Query SHOW INDEX FROM `record` 6 Query DESCRIBE `record` 6 Query SHOW INDEX FROM `record_tmp` 6 Query DESCRIBE `record_tmp` 6 Query SHOW INDEX FROM `recorded` 6 Query DESCRIBE `recorded` 6 Query SHOW INDEX FROM `recordedcredits` 6 Query DESCRIBE `recordedcredits` 6 Query SHOW INDEX FROM `recordedmarkup` 6 Query DESCRIBE `recordedmarkup` 6 Query SHOW INDEX FROM `recordedprogram` 6 Query DESCRIBE `recordedprogram` 6 Query SHOW INDEX FROM `recordedrating` 6 Query DESCRIBE `recordedrating` 6 Query SHOW INDEX FROM `recordedseek` 6 Query DESCRIBE `recordedseek` 6 Query SHOW INDEX FROM `recordingprofiles` 6 Query DESCRIBE `recordingprofiles` 6 Query SHOW INDEX FROM `recordmatch` 6 Query DESCRIBE `recordmatch` 6 Query SHOW INDEX FROM `romdb` 6 Query DESCRIBE `romdb` 6 Query SHOW INDEX FROM `schemalock` 6 Query DESCRIBE `schemalock` 6 Query SHOW INDEX FROM `settings` 6 Query DESCRIBE `settings` 6 Query SHOW INDEX FROM `tvchain` 6 Query DESCRIBE `tvchain` 6 Query SHOW INDEX FROM `videocategory` 6 Query DESCRIBE `videocategory` 6 Query SHOW INDEX FROM `videocountry` 6 Query DESCRIBE `videocountry` 6 Query SHOW INDEX FROM `videogenre` 6 Query DESCRIBE `videogenre` 6 Query SHOW INDEX FROM `videometadata` 6 Query DESCRIBE `videometadata` 6 Query SHOW INDEX FROM `videometadatacountry` 6 Query DESCRIBE `videometadatacountry` 6 Query SHOW INDEX FROM `videometadatagenre` 6 Query DESCRIBE `videometadatagenre` 6 Query SHOW INDEX FROM `videosource` 6 Query DESCRIBE `videosource` 6 Query SHOW INDEX FROM `videotypes` 6 Query DESCRIBE `videotypes` 6 Query SHOW INDEX FROM `websites` 6 Query DESCRIBE `websites` 6 Init DB mythconverg 6 Query SHOW TABLE STATUS 6 Init DB mythconverg 6 Init DB mythconverg 6 Query SHOW PROCEDURE STATUS 6 Query SHOW FUNCTION STATUS 6 Init DB mythconverg 070322 21:12:33 6 Init DB mythconverg 6 Query SHOW FULL TABLES 6 Query SHOW PROCEDURE STATUS WHERE DB='mythconverg' 6 Query SHOW FUNCTION STATUS WHERE DB='mythconverg' 6 Query select TRIGGER_NAME from information_schema.TRIGGERS where TRIGGER_SCHEMA = 'mythconverg' 6 Query show table status from `mythconverg` like "archiveitems" 6 Query show table status from `mythconverg` like "callsignnetworkmap" 6 Query show table status from `mythconverg` like "capturecard" 6 Query show table status from `mythconverg` like "cardinput" 6 Query show table status from `mythconverg` like "channel" 6 Query show table status from `mythconverg` like "codecparams" 6 Query show table status from `mythconverg` like "credits" 6 Query show table status from `mythconverg` like "customexample" 6 Query show table status from `mythconverg` like "diseqc_config" 6 Query show table status from `mythconverg` like "diseqc_tree" 6 Query show table status from `mythconverg` like "dtv_multiplex" 6 Query show table status from `mythconverg` like "dtv_privatetypes" 6 Query show table status from `mythconverg` like "dvdinput" 6 Query show table status from `mythconverg` like "dvdtranscode" 6 Query show table status from `mythconverg` like "eit_cache" 6 Query show table status from `mythconverg` like "favorites" 6 Query show table status from `mythconverg` like "filemarkup" 6 Query show table status from `mythconverg` like "gallerymetadata" 6 Query show table status from `mythconverg` like "gamemetadata" 6 Query show table status from `mythconverg` like "gameplayers" 6 Query show table status from `mythconverg` like "housekeeping" 6 Query show table status from `mythconverg` like "inuseprograms" 070322 21:12:34 6 Query show table status from `mythconverg` like "jobqueue" 6 Query show table status from `mythconverg` like "jumppoints" 6 Query show table status from `mythconverg` like "keybindings" 6 Query show table status from `mythconverg` like "keyword" 6 Query show table status from `mythconverg` like "music_albums" 6 Query show table status from `mythconverg` like "music_artists" 6 Query show table status from `mythconverg` like "music_genres" 6 Query show table status from `mythconverg` like "music_playlists" 6 Query show table status from `mythconverg` like "music_smartplaylist_categories" 6 Query show table status from `mythconverg` like "music_smartplaylist_items" 6 Query show table status from `mythconverg` like "music_smartplaylists" 6 Query show table status from `mythconverg` like "music_songs" 6 Query show table status from `mythconverg` like "music_stats" 6 Query show table status from `mythconverg` like "musicmetadata" 6 Query show table status from `mythconverg` like "musicplaylist" 6 Query show table status from `mythconverg` like "mythlog" 6 Query show table status from `mythconverg` like "mythweb_sessions" 6 Query show table status from `mythconverg` like "networkiconmap" 6 Query show table status from `mythconverg` like "oldfind" 6 Query show table status from `mythconverg` like "oldprogram" 6 Query show table status from `mythconverg` like "oldrecorded" 6 Query show table status from `mythconverg` like "people" 6 Query show table status from `mythconverg` like "phonecallhistory" 6 Query show table status from `mythconverg` like "phonedirectory" 6 Query show table status from `mythconverg` like "pidcache" 6 Query show table status from `mythconverg` like "playgroup" 6 Query show table status from `mythconverg` like "profilegroups" 6 Query show table status from `mythconverg` like "program" 6 Query show table status from `mythconverg` like "programgenres" 6 Query show table status from `mythconverg` like "programrating" 6 Query show table status from `mythconverg` like "recgrouppassword" 6 Query show table status from `mythconverg` like "record" 6 Query show table status from `mythconverg` like "record_tmp" 6 Query show table status from `mythconverg` like "recorded" 6 Query show table status from `mythconverg` like "recordedcredits" 6 Query show table status from `mythconverg` like "recordedmarkup" 6 Query show table status from `mythconverg` like "recordedprogram" 6 Query show table status from `mythconverg` like "recordedrating" 6 Query show table status from `mythconverg` like "recordedseek" 6 Query show table status from `mythconverg` like "recordingprofiles" 6 Query show table status from `mythconverg` like "recordmatch" 6 Query show table status from `mythconverg` like "romdb" 6 Query show table status from `mythconverg` like "schemalock" 6 Query show table status from `mythconverg` like "settings" 6 Query show table status from `mythconverg` like "tvchain" 6 Query show table status from `mythconverg` like "videocategory" 6 Query show table status from `mythconverg` like "videocountry" 6 Query show table status from `mythconverg` like "videogenre" 6 Query show table status from `mythconverg` like "videometadata" 6 Query show table status from `mythconverg` like "videometadatacountry" 6 Query show table status from `mythconverg` like "videometadatagenre" 6 Query show table status from `mythconverg` like "videosource" 6 Query show table status from `mythconverg` like "videotypes" 6 Query show table status from `mythconverg` like "websites" 6 Query /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, sql_mode='' */ 6 Query use mysql 6 Init DB Access denied for user 'mythtv'@'192.168.178.%' to database 'mysql'