MySQL deaktiviert?

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

MySQL deaktiviert?

Postby lalofee » 18. February 2015 11:33

hallo,

das problem ist sicher schon mehrfach vorgekommen, ich bin aber weder hier (durch die suchfunktion) noch über google zu einer lösung gekommen.
ich kenne mich mit netzwerken leider nicht besonders aus.

habe xampp installiert, kann sowohl apache als auch mysql starten, aber wenn ich mir den status ansehe, steht, dass die mysql datenbank deaktiviert ist, beim sicherheitscheck steht, "Ein MySQL Server läuft nicht oder wird von einer Firewall geblockt!".

daraufhin habe ich die firewall ausgeschaltet, es geht aber trotzdem nicht.
ich habe auch die UAC (user account control) zeitweilig deaktiviert, da bei der installation eine meldung kam, dass dies eventuell probleme verursacht. ändert auch nichts.
als firewall verwende ich outpost security free.

ich hoffe, jemand von euch kann mir helfen, ich bedanke mich schon mal im voraus, ich komme offensichtlich allein nicht mehr weiter.



hier der error log von mysql:
2015-02-18 10:38:44 6844 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 10:38:44 1914 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.
2015-02-18 10:38:44 6844 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 10:38:44 6844 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 10:38:44 6844 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 10:38:44 6844 [Note] InnoDB: Memory barrier is not used
2015-02-18 10:38:44 6844 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 10:38:44 6844 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 10:38:44 6844 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 10:38:44 6844 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 10:38:44 6844 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 10:38:44 6844 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 10:38:44 6844 [Note] InnoDB: Waiting for purge to start
2015-02-18 10:38:44 6844 [Note] InnoDB: 5.6.21 started; log sequence number 1665234
2015-02-18 10:38:44 6844 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-18 10:38:44 6844 [Note] IPv6 is available.
2015-02-18 10:38:44 6844 [Note] - '::' resolves to '::';
2015-02-18 10:38:44 6844 [Note] Server socket created on IP: '::'.
2015-02-18 10:38:45 6844 [Note] Event Scheduler: Loaded 0 events
2015-02-18 10:38:45 6844 [Note] p:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)
2015-02-18 10:48:34 7064 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 10:48:34 1b9c 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.
2015-02-18 10:48:34 7064 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 10:48:34 7064 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 10:48:34 7064 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 10:48:34 7064 [Note] InnoDB: Memory barrier is not used
2015-02-18 10:48:34 7064 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 10:48:34 7064 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 10:48:34 7064 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 10:48:34 7064 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 10:48:34 7064 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 10:48:34 7064 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665244 in the ib_logfiles!
2015-02-18 10:48:34 7064 [Note] InnoDB: Database was not shutdown normally!
2015-02-18 10:48:34 7064 [Note] InnoDB: Starting crash recovery.
2015-02-18 10:48:34 7064 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-18 10:48:35 7064 [Note] InnoDB: Restoring possible half-written data pages
2015-02-18 10:48:35 7064 [Note] InnoDB: from the doublewrite buffer...
2015-02-18 10:48:35 7064 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 10:48:35 7064 [Note] InnoDB: Waiting for purge to start
2015-02-18 10:48:35 7064 [Note] InnoDB: 5.6.21 started; log sequence number 1665244
2015-02-18 10:48:35 7064 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-18 10:48:35 7064 [Note] IPv6 is available.
2015-02-18 10:48:35 7064 [Note] - '::' resolves to '::';
2015-02-18 10:48:35 7064 [Note] Server socket created on IP: '::'.
2015-02-18 10:48:35 7064 [Note] Event Scheduler: Loaded 0 events
2015-02-18 10:48:35 7064 [Note] p:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)
2015-02-18 11:11:34 7492 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 11:11:34 1d48 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.
2015-02-18 11:11:34 7492 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 11:11:34 7492 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 11:11:34 7492 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 11:11:34 7492 [Note] InnoDB: Memory barrier is not used
2015-02-18 11:11:34 7492 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 11:11:34 7492 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 11:11:34 7492 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 11:11:34 7492 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 11:11:34 7492 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 11:11:34 7492 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-18 11:11:34 7492 [Note] InnoDB: Database was not shutdown normally!
2015-02-18 11:11:34 7492 [Note] InnoDB: Starting crash recovery.
2015-02-18 11:11:34 7492 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-18 11:11:34 7492 [Note] InnoDB: Restoring possible half-written data pages
2015-02-18 11:11:34 7492 [Note] InnoDB: from the doublewrite buffer...
2015-02-18 11:11:34 7492 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 11:11:34 7492 [Note] InnoDB: Waiting for purge to start
2015-02-18 11:11:34 7492 [Note] InnoDB: 5.6.21 started; log sequence number 1665254
2015-02-18 11:11:34 7492 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-18 11:11:34 7492 [Note] IPv6 is available.
2015-02-18 11:11:34 7492 [Note] - '::' resolves to '::';
2015-02-18 11:11:34 7492 [Note] Server socket created on IP: '::'.
2015-02-18 11:11:35 7492 [Note] Event Scheduler: Loaded 0 events
2015-02-18 11:11:35 7492 [Note] p:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)
2015-02-18 11:14:12 920 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 11:14:12 1e94 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.
2015-02-18 11:14:12 920 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 11:14:12 920 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 11:14:12 920 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 11:14:12 920 [Note] InnoDB: Memory barrier is not used
2015-02-18 11:14:12 920 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 11:14:12 920 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 11:14:12 920 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 11:14:12 920 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 11:14:13 920 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 11:14:13 920 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665264 in the ib_logfiles!
2015-02-18 11:14:13 920 [Note] InnoDB: Database was not shutdown normally!
2015-02-18 11:14:13 920 [Note] InnoDB: Starting crash recovery.
2015-02-18 11:14:13 920 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-18 11:14:13 920 [Note] InnoDB: Restoring possible half-written data pages
2015-02-18 11:14:13 920 [Note] InnoDB: from the doublewrite buffer...
2015-02-18 11:14:13 920 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 11:14:13 920 [Note] InnoDB: Waiting for purge to start
2015-02-18 11:14:13 920 [Note] InnoDB: 5.6.21 started; log sequence number 1665264
2015-02-18 11:14:13 920 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-18 11:14:13 920 [Note] IPv6 is available.
2015-02-18 11:14:13 920 [Note] - '::' resolves to '::';
2015-02-18 11:14:13 920 [Note] Server socket created on IP: '::'.
2015-02-18 11:14:13 920 [Note] Event Scheduler: Loaded 0 events
2015-02-18 11:14:13 920 [Note] p:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)
lalofee
 
Posts: 2
Joined: 18. February 2015 11:22
Operating System: Win 7

Re: MySQL deaktiviert?

Postby Altrea » 18. February 2015 12:10

Hast du irgendein Problem beim Zugriff mit phpmyadmin bzw deiner Webanwendung oder stört dich nur der u.U. falsch angezeigte Status?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: MySQL deaktiviert?

Postby lalofee » 18. February 2015 13:35

danke für deinen hinweis!

phpmyadmin funktioniert nicht, dh, wenn ich draufklicke, passiert nichts. also du denkst, es könnte auch ein anzeigefehler sein? dazu würde passen, dass im xampp controlpanel steht: mysql, status running...

anlass war, dass ich eben eine testseite nicht ansprechen konnte, also dass sie mir im webbrowser nicht angezeigt wurde. nun bin ich draufgekommen, dass ich beim schreiben der adresszeile einen denkfehler hatte. habe das ganze mal vor jahren rudimentär gelernt, aber halt wieder alles vergessen.

also es geht jetzt, danke, was es mit der anzeige, dass mysql deaktiviert ist, auf sich hat, ist zwar unklar, aber solange es funktioniert, auch egal.
lalofee
 
Posts: 2
Joined: 18. February 2015 11:22
Operating System: Win 7


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 31 guests