Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: Mysql nie działa
Forum PHP.pl > Forum > Serwery WWW
zagi195
Hej,
Przekopałem wiele stron ale nie znalazłem pomocy, więc napiszę do was.

Otóż zainstalowałem sobie wamp server, i nie działa mi mysql, w ogóle się nie włącza a ikonka wampa jest żółta, serwer działa, wszystko ładnie pięknie tylko nie baza. Dodam, że zainstalowałem to tak samo na laptopie i na nim nie ma problemu. Może coś blokuję serwer na moim komputerze?
Po próbie wejścia do phpmyadmin otrzymuję taki komunikat:

Cytat
#2002 - Serwer nie odpowiada (lub gniazdo lokalnego serwera MySQL nie jest skonfigurowane poprawnie)


Tutaj kilka linijek logów z mysql

Cytat
111222 15:32:51 [Note] Plugin 'FEDERATED' is disabled.
111222 15:32:51 InnoDB: The InnoDB memory heap is disabled
111222 15:32:51 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111222 15:32:51 InnoDB: Compressed tables use zlib 1.2.3
111222 15:32:51 InnoDB: Initializing buffer pool, size = 128.0M
111222 15:32:51 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
111222 15:32:51 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
111222 15:32:51 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
111222 15:32:51 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
111222 15:32:53 InnoDB: Waiting for the background threads to start
111222 15:32:54 InnoDB: 1.1.8 started; log sequence number 0
111222 15:32:54 [ERROR] wampmysqld: unknown option '--skip-locking'
111222 15:32:54 [ERROR] Aborting

111222 15:32:54 InnoDB: Starting shutdown...
111222 15:32:55 InnoDB: Shutdown completed; log sequence number 1595675
111222 15:32:55 [Note]
111222 15:33:57 [Note] Plugin 'FEDERATED' is disabled.
111222 15:33:57 InnoDB: The InnoDB memory heap is disabled
111222 15:33:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111222 15:33:57 InnoDB: Compressed tables use zlib 1.2.3
111222 15:33:57 InnoDB: Initializing buffer pool, size = 128.0M
111222 15:33:57 InnoDB: Completed initialization of buffer pool
111222 15:33:57 InnoDB: highest supported file format is Barracuda.
111222 15:33:58 InnoDB: Waiting for the background threads to start
111222 15:33:59 InnoDB: 1.1.8 started; log sequence number 1595675
111222 15:33:59 [ERROR] wampmysqld: unknown option '--skip-locking'
111222 15:33:59 [ERROR] Aborting

111222 15:33:59 InnoDB: Starting shutdown...
111222 15:33:59 InnoDB: Shutdown completed; log sequence number 1595675
111222 15:33:59 [Note]
111222 15:34:45 [Note] Plugin 'FEDERATED' is disabled.
111222 15:34:45 InnoDB: The InnoDB memory heap is disabled
111222 15:34:45 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111222 15:34:45 InnoDB: Compressed tables use zlib 1.2.3
111222 15:34:45 InnoDB: Initializing buffer pool, size = 128.0M
111222 15:34:45 InnoDB: Completed initialization of buffer pool
111222 15:34:45 InnoDB: highest supported file format is Barracuda.
111222 15:34:46 InnoDB: Waiting for the background threads to start
111222 15:34:47 InnoDB: 1.1.8 started; log sequence number 1595675
111222 15:34:47 [ERROR] wampmysqld: unknown option '--skip-locking'
111222 15:34:47 [ERROR] Aborting

111222 15:34:47 InnoDB: Starting shutdown...
111222 15:34:47 InnoDB: Shutdown completed; log sequence number 1595675
111222 15:34:47 [Note]
111222 15:35:24 [Note] Plugin 'FEDERATED' is disabled.
111222 15:35:24 InnoDB: The InnoDB memory heap is disabled
111222 15:35:24 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111222 15:35:24 InnoDB: Compressed tables use zlib 1.2.3
111222 15:35:24 InnoDB: Initializing buffer pool, size = 128.0M
111222 15:35:24 InnoDB: Completed initialization of buffer pool
111222 15:35:24 InnoDB: highest supported file format is Barracuda.
111222 15:35:24 InnoDB: Waiting for the background threads to start
111222 15:35:25 InnoDB: 1.1.8 started; log sequence number 1595675
111222 15:35:25 [ERROR] wampmysqld: unknown option '--skip-locking'
111222 15:35:25 [ERROR] Aborting

111222 15:35:25 InnoDB: Starting shutdown...
111222 15:35:26 InnoDB: Shutdown completed; log sequence number 1595675
111222 15:35:26 [Note]
111222 15:40:04 [Note] Plugin 'FEDERATED' is disabled.
111222 15:40:04 InnoDB: The InnoDB memory heap is disabled
111222 15:40:04 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111222 15:40:04 InnoDB: Compressed tables use zlib 1.2.3
111222 15:40:04 InnoDB: Initializing buffer pool, size = 128.0M
111222 15:40:04 InnoDB: Completed initialization of buffer pool
111222 15:40:04 InnoDB: highest supported file format is Barracuda.
111222 15:40:04 InnoDB: Waiting for the background threads to start
111222 15:40:05 InnoDB: 1.1.8 started; log sequence number 1595675
111222 15:40:05 [ERROR] wampmysqld: unknown option '--skip-locking'
111222 15:40:05 [ERROR] Aborting

111222 15:40:05 InnoDB: Starting shutdown...
111222 15:40:06 InnoDB: Shutdown completed; log sequence number 1595675
111222 15:40:06 [Note]


Jakieś propozycje? (Skype wyłączony portu 80 nic nie wykorzystuję prócz apache)
Shili
http://forum.wampserver.com/read.php?2,72108,72130

Próbowałeś wykorzystać rozwiązanie podane w powyższym wątku?
Rozumiem, że nie działa?

zagi195
Niestety nie działa.
abort
Kod
111222 15:40:05 [ERROR] wampmysqld: unknown option '--skip-locking'
111222 15:40:05 [ERROR] Aborting

Tu masz problem.
Wywal "--skip-locking" podczas uruchamiania wampmysqld, powinno pomóc. Niestety, wampa nie używam, więc nie pomogę ze szczegółami, ale może ktoś bardziej obeznany coś szepnie.
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.