Help running MYSQL on server

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Help running MYSQL on server

Postby martin286 » 09. April 2014 18:43

I'm trying to set up XAMPP on a remote serve which I connect through windows remote server.

I couldn't launch neither Apache or MYSQL.
The apache problem I already solved it by stopping the service "Web deployment agent service" since it was using the same port that I needed to run apache (port 80).

Now I have to fix MYSLQ and none of the solutions I found here worked.

Please help :(

Here is the log:

2014-04-09 14:41:19 3800 [Note] Plugin 'FEDERATED' is disabled.
2014-04-09 14:41:19 cc8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-04-09 14:41:19 3800 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-04-09 14:41:19 3800 [Note] InnoDB: The InnoDB memory heap is disabled
2014-04-09 14:41:19 3800 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-04-09 14:41:19 3800 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-04-09 14:41:19 3800 [Note] InnoDB: Not using CPU crc32 instructions
2014-04-09 14:41:19 3800 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-04-09 14:41:19 3800 [Note] InnoDB: Completed initialization of buffer pool
2014-04-09 14:41:19 3800 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2014-04-09 14:41:19 3800 [ERROR] InnoDB: The system tablespace must be writable!
2014-04-09 14:41:19 3800 [ERROR] Plugin 'InnoDB' init function returned error.
2014-04-09 14:41:19 3800 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-04-09 14:41:19 3800 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-04-09 14:41:19 3800 [ERROR] Aborting

2014-04-09 14:41:19 3800 [Note] Binlog end
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'partition'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_METRICS'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_CMP'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'INNODB_TRX'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'BLACKHOLE'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'ARCHIVE'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'MRG_MYISAM'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'MyISAM'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'MEMORY'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'CSV'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'sha256_password'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'mysql_old_password'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'mysql_native_password'
2014-04-09 14:41:19 3800 [Note] Shutting down plugin 'binlog'
2014-04-09 14:41:19 3800 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
martin286
 
Posts: 2
Joined: 09. April 2014 18:32
Operating System: windows 8

Re: Help running MYSQL on server

Postby mforester » 10. April 2014 23:31

I have the same problem on Windows Server 2012, my install directory and all subs are set to Read Only so I'm trying to figure out what needs to change.
mforester
 
Posts: 2
Joined: 03. August 2011 20:38

Re: Help running MYSQL on server

Postby martin286 » 11. April 2014 14:51

I figured out. It was a silly thing, someone had already installed SQL (mysql) so I already had SQL running :)

You can close this thread, thanks !
martin286
 
Posts: 2
Joined: 09. April 2014 18:32
Operating System: windows 8


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 45 guests