2016-03-15T18:53:55.682712Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-15T18:53:55.682712Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2016-03-15T18:53:55.682712Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-03-15T18:53:55.682712Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2016-03-15T18:53:55.683712Z 0 [Note] c:\openserver\modules\database\MySQL-5.7\bin\mysqld.exe (mysqld 5.7.10) starting as process 5328 ...
2016-03-15T18:53:55.692712Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-15T18:53:55.692712Z 0 [Note] InnoDB: Uses event mutexes
2016-03-15T18:53:55.692712Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-03-15T18:53:55.692712Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-15T18:53:55.693712Z 0 [Note] InnoDB: Number of pools: 1
2016-03-15T18:53:55.693712Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-15T18:53:55.729714Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-03-15T18:53:55.744715Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-03-15T18:53:56.019731Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-15T18:53:56.544761Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-15T18:53:56.544761Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-15T18:53:56.886781Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-03-15T18:53:56.890781Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-15T18:53:56.890781Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-15T18:53:56.891781Z 0 [Note] InnoDB: Waiting for purge to start
2016-03-15T18:53:56.944784Z 0 [Note] InnoDB: 5.7.10 started; log sequence number 1209980
2016-03-15T18:53:56.945784Z 0 [Note] InnoDB: Loading buffer pool(s) from c:\openserver\modules\database\MySQL-5.7\data\ib_buffer_pool
2016-03-15T18:53:56.945784Z 0 [Note] InnoDB: not started
2016-03-15T18:53:56.945784Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-03-15T18:53:56.947784Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-03-15T18:53:56.948784Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-03-15T18:53:56.949784Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-15T18:53:56.950784Z 0 [Note] IPv6 is available.
2016-03-15T18:53:56.950784Z 0 [Note] - '::' resolves to '::';
2016-03-15T18:53:56.950784Z 0 [Note] Server socket created on IP: '::'.
2016-03-15T18:53:56.952784Z 0 [Warning] Failed to open optimizer cost constant tables
Donald Dak: Попробуйте запустить mysql в режиме --skip-grant-tables
Что бы это сделать проще всего добавить строчку skip-grant-tables в файле my.ini в секции [mysqld]
Николай: 2016-03-15T18:53:57.007787Z 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2016-03-15T18:53:57.008787Z 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2016-03-15T18:53:57.186798Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160315 23:53:57
2016-03-15T18:53:57.215799Z 0 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
2016-03-15T18:53:57.215799Z 0 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
2016-03-15T18:53:57.215799Z 0 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2016-03-15T18:53:57.215799Z 0 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
2016-03-15T18:53:57.265802Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2016-03-15T18:53:57.265802Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
2016-03-15T18:53:57.265802Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
2016-03-15T18:53:57.265802Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2016-03-15T18:53:57.323806Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2016-03-15T18:53:57.323806Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
2016-03-15T18:53:57.324806Z 0 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
2016-03-15T18:53:57.324806Z 0 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
2016-03-15T18:53:57.324806Z 0 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
2016-03-15T18:53:57.324806Z 0 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2016-03-15T18:53:57.325806Z 0 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
2016-03-15T18:53:57.325806Z 0 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2016-03-15T18:53:57.373808Z 0 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
2016-03-15T18:53:57.373808Z 0 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
2016-03-15T18:53:57.373808Z 0 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2016-03-15T18:53:57.374808Z 0 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
2016-03-15T18:53:57.374808Z 0 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
2016-03-15T18:53:57.374808Z 0 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2016-03-15T18:53:57.374808Z 0 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
2016-03-15T18:53:57.374808Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2016-03-15T18:53:57.376809Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2016-03-15T18:53:57.376809Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2016-03-15T18:53:57.376809Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2016-03-15T18:53:57.376809Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2016-03-15T18:53:57.376809Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure
2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure
2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure
2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure
2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure
2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure
2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure
2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure
2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure
2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2016-03-15T18:53:57.380809Z 0 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2016-03-15T18:53:57.380809Z 0 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2016-03-15T18:53:57.380809Z 0 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2016-03-15T18:53:57.380809Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2016-03-15T18:53:57.380809Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure
2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure
2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure
2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure
2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure
2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure
2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure
2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure
2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure
2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure
2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure
2016-03-15T18:53:57.383809Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure
2016-03-15T18:53:57.383809Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure
2016-03-15T18:53:57.383809Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure
2016-03-15T18:53:57.383809Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure
2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure
2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure
2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure
2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure
2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure
2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure
2016-03-15T18:53:57.404810Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure
2016-03-15T18:53:57.404810Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure
2016-03-15T18:53:57.404810Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure
2016-03-15T18:53:57.404810Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure
2016-03-15T18:53:57.404810Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure
2016-03-15T18:53:57.405810Z 0 [Note] c:\openserver\modules\database\MySQL-5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.10' socket: '' port: 3306 MySQL Community Server (GPL)
Николай: Да винда 7, эту MySQL 5.7.10 скачал просто сайта и установил в папку
C:\openserver\modules\database\MySQL-5.7, папку data создал ее не было, этот лог и есть от нее!
А MySQL 5.7.11 скачал с оффа там она была в zip, ту удалил и скопировал туда же, и все равно таже ошибка.
Когда я туда закидываю там .ini называется my-defualt.ini если его не сделать в my то пишет что такого нет, и папки data тоже нет вот что в скаченном ini
# For advice on how to change settings please see
# dev.mysql.com/doc/refman/5.7/en/server-configurati...
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
Donald Dak: мускль в любом случае - "отдельный сервер")
устанавливаете нужный вам (в данном случае 5.7) рядом с старой версией (полагаю C:\openserver\modules\database\MySQL-{version})
в настроках опенсервера указываете версию
должно работать
Простой
