Страница 1 из 1

Mysql

Добавлено: 16 апр 2016, 18:49
Tumour
Все привет, у меня проблема, решил перейти с mysql 5.5 на mysql 5.7, поменял в настройках на mysql 5.7, теперь команда sql INSERT INTO не хочет записывать данные в базу, UPDATE SET работает, выборка тоже работает SELECT * FROM, а создать новое поле в mysql 5.7 я не могу, причем просто переключаюсь на mysql 5.5 все прекрасно работает.
Использую
php 7 x64
apache php 7 x64

Re: Mysql

Добавлено: 16 апр 2016, 18:56
Tumour
2016-04-16T15:16:32.651966Z 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-04-16T15:16:32.651966Z 0 [Note] c:\openserver\modules\database\MySQL-5.7-x64\bin\mysqld.exe (mysqld 5.7.11-log) starting as process 8016 ...
2016-04-16T15:16:32.657971Z 0 [ERROR] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'
2016-04-16T15:16:32.658470Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-04-16T15:16:32.658470Z 0 [Note] InnoDB: Uses event mutexes
2016-04-16T15:16:32.658470Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-04-16T15:16:32.658971Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-16T15:16:32.658971Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2016-04-16T15:16:32.658971Z 0 [Note] InnoDB: Number of pools: 1
2016-04-16T15:16:32.659471Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-16T15:16:32.709530Z 0 [Note] InnoDB: Initializing buffer pool, total size = 20M, instances = 1, chunk size = 20M
2016-04-16T15:16:32.710528Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-04-16T15:16:32.858223Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-16T15:16:33.384525Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-04-16T15:16:33.385526Z 0 [Note] InnoDB: Setting file 'c:\openserver\userdata\MySQL-5.7-x64\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-04-16T15:16:33.568464Z 0 [Note] InnoDB: File 'c:\openserver\userdata\MySQL-5.7-x64\ibtmp1' size is now 12 MB.
2016-04-16T15:16:33.626269Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-04-16T15:16:33.626269Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-04-16T15:16:33.627269Z 0 [Note] InnoDB: Waiting for purge to start
2016-04-16T15:16:33.687324Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 8775962
2016-04-16T15:16:33.687324Z 0 [Note] InnoDB: Loading buffer pool(s) from c:\openserver\userdata\MySQL-5.7-x64\ib_buffer_pool
2016-04-16T15:16:33.688327Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-04-16T15:16:34.047666Z 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-04-16T15:16:34.047666Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160416 18:16:34
2016-04-16T15:16:34.047666Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2016-04-16T15:16:34.049689Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2016-04-16T15:16:34.050689Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2016-04-16T15:16:34.192335Z 0 [Note] Event Scheduler: Loaded 0 events
2016-04-16T15:16:34.193336Z 0 [Note] c:\openserver\modules\database\MySQL-5.7-x64\bin\mysqld.exe: ready for connections.
Version: '5.7.11-log' socket: '' port: 3306 MySQL Community Server (GPL)
2016-04-16T15:27:35.898467Z 71 [Note] Access denied for user 'mysql'@'localhost' (using password: YES)
2016-04-16T15:27:35.899468Z 72 [Note] Access denied for user 'mysql'@'localhost' (using password: NO)

Лог MySQL отладка