Posted By: Rishi_P on October 27, 2017, 7:20 am | Post: 2 |
Hi Dante,
In AMPPS 3.8, you can install remaining Apps from Apps section. Start Ampps, login to localhost/ampps and click on Apps button or access following url: http://localhost/ampps/index.php?act=ampps_apps For MySQL: If you are using Windows machine then install VC 10 Library: https://www.microsoft.com/en-in/download/confirmation.aspx?id=5555 Note: Install x86(32 Bit), because Ampps is 32 Bit. And if you are using other than windows, then open Terminal and run following command and let us know the output: /path/to/Ampps/mysql/bin/mysqld Note: Use actual path to Ampps directory. |
Posted By: dante_96 on October 29, 2017, 9:15 am | Post: 3 |
@Rishi P
Thanks! its works fine now |
Posted By: Vartex05 on December 4, 2017, 10:31 am | Post: 4 |
Hi, i have a problem with mysql in ampps 3.8. Iam using ampps, so i can run my php app, everything works great at the beginning - i install ampps, go to localhost/ampps, login into phpadmin, create database i need, import sql, copy my app into ww folder and run in it... everything works. But when i then turn mysql off, it wont start again, iam getting this in error log :
Code 2017-12-04 11:10:42 1052 [Note] Giving 0 client threads a chance to die gracefully 2017-12-04 11:10:42 1052 [Note] Event Scheduler: Purging the queue. 0 events 2017-12-04 11:10:42 1052 [Note] Shutting down slave threads 2017-12-04 11:10:42 1052 [Note] Forcefully disconnecting 0 remaining clients 2017-12-04 11:10:42 1052 [Note] Binlog end 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'partition' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_METRICS' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_CMPMEM' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_CMP' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_LOCKS' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'INNODB_TRX' 2017-12-04 11:10:42 1052 [Note] Shutting down plugin 'InnoDB' 2017-12-04 11:10:42 1052 [Note] InnoDB: FTS optimize thread exiting. 2017-12-04 11:10:42 1052 [Note] InnoDB: Starting shutdown... 2017-12-04 11:10:44 1052 [Note] InnoDB: Shutdown completed; log sequence number 1949929 2017-12-04 11:10:44 1052 [Note] Shutting down plugin 'BLACKHOLE' 2017-12-04 11:10:44 1052 [Note] Shutting down plugin 'ARCHIVE' 2017-12-04 11:10:44 1052 [Note] Shutting down plugin 'MRG_MYISAM' 2017-12-04 11:10:44 1052 [Note] Shutting down plugin 'MyISAM' 2017-12-04 11:10:44 1052 [Note] Shutting down plugin 'MEMORY' 2017-12-04 11:10:44 1052 [Note] Shutting down plugin 'CSV' 2017-12-04 11:10:44 1052 [Note] Shutting down plugin 'sha256_password' 2017-12-04 11:10:44 1052 [Note] Shutting down plugin 'mysql_old_password' 2017-12-04 11:10:44 1052 [Note] Shutting down plugin 'mysql_native_password' 2017-12-04 11:10:44 1052 [Note] Shutting down plugin 'binlog' 2017-12-04 11:10:44 1052 [Note] mysql\bin\mysqld.exe: Shutdown complete 2017-12-04 11:11:49 2960 [Warning] You need to use --log-bin to make --binlog-format work. 2017-12-04 11:11:49 2960 [Note] Plugin 'FEDERATED' is disabled. 2017-12-04 11:11:49 2960 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-12-04 11:11:49 2960 [Note] InnoDB: The InnoDB memory heap is disabled 2017-12-04 11:11:49 2960 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2017-12-04 11:11:49 2960 [Note] InnoDB: Memory barrier is not used 2017-12-04 11:11:49 2960 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-12-04 11:11:49 2960 [Note] InnoDB: Not using CPU crc32 instructions 2017-12-04 11:11:49 2960 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-12-04 11:11:49 2960 [Note] InnoDB: Completed initialization of buffer pool 2017-12-04 11:11:49 2960 [Note] InnoDB: Highest supported file format is Barracuda. 2017-12-04 11:11:49 918 InnoDB: Operating system error number 87 in a file operation. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html 2017-12-04 11:11:49 2960 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation Any ideas how to fix this? Sry that iam posting here, but i cant post new topic as new user :/ |
Posted By: Rishi_P on December 5, 2017, 10:27 am | Post: 5 |
Hi,
Try this: Open MySQL Config (AMPPS Panel --> MySQL --> Configuration), add following line: innodb_flush_method=normal Restart MySQL. |
Posted By: maisnet on April 3, 2018, 12:47 pm | Post: 6 |
Obrigado. Funcionou na perfeição. O sistema havia instalado a versão 64Bits. Coloquei a de 32 e ficou a cem por cento.
Obrigado |