krejcomut

hello got problem with mysql i tried fix it but without success 190510 21:06:30 mysqld_safe Logging to '/var/db/mysql/vmi263479.contaboserver.net.err'. 190510 21:06:30 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2019-05-10 21:06:31 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-05-10 21:06:31 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.43) starting as process 897 ... 2019-05-10 21:06:31 897 [Note] Plugin 'FEDERATED' is disabled. 2019-05-10 21:06:31 897 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-05-10 21:06:31 897 [Note] InnoDB: The InnoDB memory heap is disabled 2019-05-10 21:06:31 897 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-10 21:06:31 897 [Note] InnoDB: Memory barrier is not used 2019-05-10 21:06:31 897 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-10 21:06:31 897 [Note] InnoDB: Using CPU crc32 instructions 2019-05-10 21:06:31 897 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2019-05-10 21:06:31 897 [Note] InnoDB: Completed initialization of buffer pool 2019-05-10 21:06:31 897 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2019-05-10 21:06:31 897 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2019-05-10 21:06:31 897 [Note] InnoDB: Database physically writes the file full: wait... 2019-05-10 21:06:31 897 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2019-05-10 21:06:31 897 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2019-05-10 21:06:31 897 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2019-05-10 21:06:31 897 [Warning] InnoDB: New log files created, LSN=45781 2019-05-10 21:06:31 897 [Note] InnoDB: Doublewrite buffer not found: creating new 2019-05-10 21:06:31 897 [Note] InnoDB: Doublewrite buffer created 2019-05-10 21:06:31 897 [Note] InnoDB: 128 rollback segment(s) are active. 2019-05-10 21:06:31 897 [Warning] InnoDB: Creating foreign key constraint system tables. 2019-05-10 21:06:31 897 [Note] InnoDB: Foreign key constraint system tables created 2019-05-10 21:06:31 897 [Note] InnoDB: Creating tablespace and datafile system tables. 2019-05-10 21:06:31 897 [Note] InnoDB: Tablespace and datafile system tables created. 2019-05-10 21:06:31 897 [Note] InnoDB: Waiting for purge to start 2019-05-10 21:06:31 897 [Note] InnoDB: 5.6.43 started; log sequence number 0 2019-05-10 21:06:31 897 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work. 2019-05-10 21:06:31 897 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work. 2019-05-10 21:06:31 897 [Note] Server hostname (bind-address): '*'; port: 3306 2019-05-10 21:06:31 897 [Note] IPv6 is available. 2019-05-10 21:06:31 897 [Note] - '::' resolves to '::'; 2019-05-10 21:06:31 897 [Note] Server socket created on IP: '::'. 2019-05-10 21:06:31 897 [ERROR] Event Scheduler: Failed to open table mysql.event 2019-05-10 21:06:31 897 [ERROR] Event Scheduler: Error while loading from disk. 2019-05-10 21:06:31 897 [Note] Event Scheduler: Purging the queue. 0 events 2019-05-10 21:06:31 897 [ERROR] Aborting 2019-05-10 21:06:31 897 [Note] Binlog end 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'partition' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_METRICS' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_CMPMEM' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_CMP' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_LOCKS' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'INNODB_TRX' 2019-05-10 21:06:31 897 [Note] Shutting down plugin 'InnoDB' 2019-05-10 21:06:31 897 [Note] InnoDB: FTS optimize thread exiting. 2019-05-10 21:06:31 897 [Note] InnoDB: Starting shutdown... 2019-05-10 21:06:33 897 [Note] InnoDB: Shutdown completed; log sequence number 1600607 2019-05-10 21:06:33 897 [Note] Shutting down plugin 'BLACKHOLE' 2019-05-10 21:06:33 897 [Note] Shutting down plugin 'ARCHIVE' 2019-05-10 21:06:33 897 [Note] Shutting down plugin 'MRG_MYISAM' 2019-05-10 21:06:33 897 [Note] Shutting down plugin 'MyISAM' 2019-05-10 21:06:33 897 [Note] Shutting down plugin 'MEMORY' 2019-05-10 21:06:33 897 [Note] Shutting down plugin 'CSV' 2019-05-10 21:06:33 897 [Note] Shutting down plugin 'sha256_password' 2019-05-10 21:06:33 897 [Note] Shutting down plugin 'mysql_old_password' 2019-05-10 21:06:33 897 [Note] Shutting down plugin 'mysql_native_password' 2019-05-10 21:06:33 897 [Note] Shutting down plugin 'binlog' 2019-05-10 21:06:33 897 [Note] /usr/local/libexec/mysqld: Shutdown complete Error in my_thread_global_end(): 1 threads didn't exit 190510 21:06:38 mysqld_safe mysqld from pid file /var/db/mysql/vmi263479.contaboserver.net.pid ended 2019-05-10 21:08:12 966 [Note] Plugin 'FEDERATED' is disabled. 2019-05-10 21:08:12 966 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-05-10 21:08:12 966 [Note] InnoDB: The InnoDB memory heap is disabled 2019-05-10 21:08:12 966 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-10 21:08:12 966 [Note] InnoDB: Memory barrier is not used 2019-05-10 21:08:12 966 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-10 21:08:12 966 [Note] InnoDB: Using CPU crc32 instructions 2019-05-10 21:08:12 966 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2019-05-10 21:08:12 966 [Note] InnoDB: Completed initialization of buffer pool 2019-05-10 21:08:12 966 [Note] InnoDB: Highest supported file format is Barracuda. 2019-05-10 21:08:12 966 [Note] InnoDB: 128 rollback segment(s) are active. 2019-05-10 21:08:12 966 [Note] InnoDB: Waiting for purge to start 2019-05-10 21:08:12 966 [Note] InnoDB: 5.6.43 started; log sequence number 1600607 2019-05-10 21:08:12 966 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work. 2019-05-10 21:08:12 966 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work. 2019-05-10 21:08:12 966 [Note] Server hostname (bind-address): '*'; port: 3306 2019-05-10 21:08:12 966 [Note] IPv6 is available. 2019-05-10 21:08:12 966 [Note] - '::' resolves to '::'; 2019-05-10 21:08:12 966 [Note] Server socket created on IP: '::'. 2019-05-10 21:08:12 966 [ERROR] Event Scheduler: Failed to open table mysql.event 2019-05-10 21:08:12 966 [ERROR] Event Scheduler: Error while loading from disk. 2019-05-10 21:08:12 966 [Note] Event Scheduler: Purging the queue. 0 events 2019-05-10 21:08:12 966 [ERROR] Aborting 2019-05-10 21:08:12 966 [Note] Binlog end 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'partition' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_METRICS' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_CMPMEM' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_CMP' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_LOCKS' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'INNODB_TRX' 2019-05-10 21:08:12 966 [Note] Shutting down plugin 'InnoDB' 2019-05-10 21:08:12 966 [Note] InnoDB: FTS optimize thread exiting. 2019-05-10 21:08:12 966 [Note] InnoDB: Starting shutdown... 2019-05-10 21:08:14 966 [Note] InnoDB: Shutdown completed; log sequence number 1600617 2019-05-10 21:08:14 966 [Note] Shutting down plugin 'BLACKHOLE' 2019-05-10 21:08:14 966 [Note] Shutting down plugin 'ARCHIVE' 2019-05-10 21:08:14 966 [Note] Shutting down plugin 'MRG_MYISAM' 2019-05-10 21:08:14 966 [Note] Shutting down plugin 'MyISAM' 2019-05-10 21:08:14 966 [Note] Shutting down plugin 'MEMORY' 2019-05-10 21:08:14 966 [Note] Shutting down plugin 'CSV' 2019-05-10 21:08:14 966 [Note] Shutting down plugin 'sha256_password' 2019-05-10 21:08:14 966 [Note] Shutting down plugin 'mysql_old_password' 2019-05-10 21:08:14 966 [Note] Shutting down plugin 'mysql_native_password' 2019-05-10 21:08:14 966 [Note] Shutting down plugin 'binlog' 2019-05-10 21:08:14 966 [Note] /usr/local/libexec/mysqld: Shutdown complete Error in my_thread_global_end(): 1 threads didn't exit EDIT : i did mysql safe start -grant skip tables but after that saying in mysql on read only my discord : TOCHKYN#6656

hello i setup my server i fix my self almost everything but cant connect with client ROOT has been unpacked adn packed again with vm ip thanks for help HLLRHLLR#7627

in file: './account/account.frm'

okey 40 k i go try find

hello all i sreach source of client 34k to moddifing ..

me too i cant login

work on public ? or only local

what client ?