Mysql startet nicht

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

Mysql startet nicht

Postby Maltbue » 02. March 2016 17:02

2015-11-10 15:26:56 10fc 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-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-03-02 16:51:02 a0c 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.
2016-03-02 16:51:02 2572 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-03-02 16:51:02 2572 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-02 16:51:02 2572 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-02 16:51:02 2572 [Note] InnoDB: Memory barrier is not used
2016-03-02 16:51:02 2572 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-02 16:51:02 2572 [Note] InnoDB: Using generic crc32 instructions
2016-03-02 16:51:02 2572 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-03-02 16:51:02 2572 [Note] InnoDB: Completed initialization of buffer pool
2016-03-02 16:51:02 2572 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-02 16:51:02 2572 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-02 16:51:02 2572 [Note] InnoDB: Waiting for purge to start
2016-03-02 16:51:02 2572 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 1835037
2016-03-02 16:51:02 5680 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-03-02 16:51:02 2572 [Note] Plugin 'FEEDBACK' is disabled.
2016-03-02 16:51:02 2572 [Note] Server socket created on IP: '::'.
2016-03-02 16:51:02 2572 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.10-MariaDB' socket: '' port: 3307 mariadb.org binary distribution


Anfangs war Apache und mysql rot, dann habe ich bei apache die ports laut anleitung gewechselt.
über my.ini habe ich bei mysql von 3306 auf 3307 gewechselt.

16:51:22 [main] Aktiviere Autostart für Modul "MySQL"
16:51:22 [main] Starte Check-Timer
16:51:22 [main] Control Panel bereit
16:51:23 [Apache] Autostart abgebrochen: Apache ist bereits gestartet
16:51:23 [mysql] Autostart aktiv: Starte...
16:51:23 [mysql] XAMPP MySQL ist bereits gestartet auf Port 3307
16:51:23 [mysql] Versuche MySQL Windows Dienst zu starten...


weiter passiert nichts und es wird auch nicht grün. Ich bin Anfänger, wo liegt der Fehler?
Maltbue
 
Posts: 3
Joined: 02. March 2016 16:57
Operating System: Windows 10

Re: Mysql startet nicht

Postby Altrea » 02. March 2016 19:34

Hast du geänderte Ports auch in der Control Panel Konfiguration angepasst?
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: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Mysql startet nicht

Postby Maltbue » 02. March 2016 20:55

Ja das habe ich
Maltbue
 
Posts: 3
Joined: 02. March 2016 16:57
Operating System: Windows 10

Re: Mysql startet nicht

Postby Altrea » 02. March 2016 22:10

Dann passt doch alles.

Das Control Panel sagt ja auch, dass MySQL bereits über die Control Panel Autostartfunktion gestartet wurde. Daher kann es nicht zusätzlich als Windows Dienst gestartet werden.
Entscheide dich für nur eine der beiden Startvarianten.
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: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Mysql startet nicht

Postby Maltbue » 03. March 2016 20:21

kam heute nicht mehr dazu, aber werde das morgen mal mit einer installation testen, möchte was in wordpress programmieren
Maltbue
 
Posts: 3
Joined: 02. March 2016 16:57
Operating System: Windows 10


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 32 guests