• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

xampp mysql not work

vexler222

Member
Joined
Apr 22, 2012
Messages
501
Solutions
6
Reaction score
14
Hi, yesterday it work normally, today i can't start mysql someone can help me?


xDATLDU.png



Logs:
Code:
2021-10-19 20:34:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-10-19 20:34:42 0 [Note] InnoDB: Uses event mutexes
2021-10-19 20:34:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-10-19 20:34:42 0 [Note] InnoDB: Number of pools: 1
2021-10-19 20:34:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-10-19 20:34:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-10-19 20:34:42 0 [Note] InnoDB: Completed initialization of buffer pool
2021-10-19 20:34:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-10-19 20:34:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-10-19 20:34:43 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-10-19 20:34:43 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-10-19 20:34:43 0 [Note] InnoDB: Waiting for purge to start
2021-10-19 20:34:43 0 [Note] InnoDB: 10.4.14 started; log sequence number 108307733; transaction id 36914
2021-10-19 20:34:43 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-10-19 20:34:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-10-19 20:34:43 0 [Note] Server socket created on IP: '::'.
 

Terotrificy

Well-Known Member
Joined
Oct 18, 2020
Messages
247
Solutions
9
Reaction score
81
Location
Santiago, Chile.
Try using the MySQL backup folder which is included with XAMPP.
  1. Rename the folder mysql/data to mysql/data_old (you can use any name)
  2. Create a new folder mysql/data
  3. Copy the content that resides in mysql/backup to the new mysql/data folder
  4. Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
  5. Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
  6. Start MySQL from XAMPP control panel
 
OP
OP
vexler222

vexler222

Member
Joined
Apr 22, 2012
Messages
501
Solutions
6
Reaction score
14
check you don't already have a mysql process running on port 3306.
how to check it? where

Try using the MySQL backup folder which is included with XAMPP.
  1. Rename the folder mysql/data to mysql/data_old (you can use any name)
  2. Create a new folder mysql/data
  3. Copy the content that resides in mysql/backup to the new mysql/data folder
  4. Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
  5. Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
  6. Start MySQL from XAMPP control panel
still not work
 

Boy67

Intermediate OT User
Joined
Jul 4, 2007
Messages
265
Solutions
11
Reaction score
108
Location
England
open cmd (run as administrator) and type in:
netstat -a -b

See if you can find 0.0.0.0:3306 or something similar with the port 3306 or whichever port your mysql is running on.
 
OP
OP
vexler222

vexler222

Member
Joined
Apr 22, 2012
Messages
501
Solutions
6
Reaction score
14
open cmd (run as administrator) and type in:
netstat -a -b

See if you can find 0.0.0.0:3306 or something similar with the port 3306 or whichever port your mysql is running on.
I dont see anything with 3306, i'm tryed restart pc but not help.
Yesterday all worked, i don't know what happened today... I dont change anything with xampp
 

Boy67

Intermediate OT User
Joined
Jul 4, 2007
Messages
265
Solutions
11
Reaction score
108
Location
England
Strange, I still think here is most likely a service using this port. Open up task manager and search for any services that has a name including "mysql"

Otherwise, change the port to 3307.
 
OP
OP
vexler222

vexler222

Member
Joined
Apr 22, 2012
Messages
501
Solutions
6
Reaction score
14
Strange, I still think here is most likely a service using this port. Open up task manager and search for any services that has a name including "mysql"

Otherwise, change the port to 3307.

I dont see too with MySQL prefix, how change port? Its so strange because i dont change anything and i dont installed any apps from yesterday :/


Did you try to restart and open xampp with admin privileges?
I tryed, restart xampp restart pc and still nothing
 
Top