I was working on my little database on phpmyadmin, I rebooted my PC and now I can't use phpmyadmin anymore.
To solve the problem I tried the most common solutions I found on the web:
1)moved "ibdata1" from the mysql/data directory to another folder (so I have a backup just in case)
2)following this tutorial https://www.youtube.com/watch?v=_U2kTpcLNhE I changed "Listen 80" to "Listen 8080" and "ServerName localhost:80" to "ServerName localhost:8080" in httpd.conf
3)again from the tutorial I changed "Listen 443" to "Listen 4433" from httpd-sll.conf
MySQL 8.0 command line client is installed too on my pc.
Anyway here's the logs, I hope you'll help me to find a solution
XAMPP control panel
- Code: Select all
18.07.09 [main] Initializing Control Panel
18.07.09 [main] Windows Version: Enterprise 64-bit
18.07.09 [main] XAMPP Version: 7.2.31
18.07.09 [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
18.07.09 [main] You are not running with administrator rights! This will work for
18.07.09 [main] most application stuff but whenever you do something with services
18.07.09 [main] there will be a security dialogue or things will break! So think
18.07.09 [main] about running this application with administrator rights!
18.07.09 [main] XAMPP Installation Directory: "d:\programmi\xampproot2\"
18.07.09 [main] Checking for prerequisites
18.07.09 [main] All prerequisites found
18.07.09 [main] Initializing Modules
18.07.10 [mysql] Problem detected!
18.07.10 [mysql] Port 3306 in use by "Unable to open process"!
18.07.10 [mysql] MySQL WILL NOT start without the configured ports free!
18.07.10 [mysql] You need to uninstall/disable/reconfigure the blocking application
18.07.10 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
18.07.10 [main] The FileZilla module is disabled
18.07.10 [main] The Mercury module is disabled
18.07.10 [main] The Tomcat module is disabled
18.07.10 [main] Starting Check-Timer
18.07.10 [main] Control Panel Ready
18.07.12 [Apache] Attempting to start Apache app...
18.07.13 [Apache] Status change detected: running
18.07.16 [mysql] Problem detected!
18.07.16 [mysql] Port 3306 in use by "Unable to open process"!
18.07.16 [mysql] MySQL WILL NOT start without the configured ports free!
18.07.16 [mysql] You need to uninstall/disable/reconfigure the blocking application
18.07.16 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
18.07.16 [mysql] Attempting to start MySQL app...
18.07.17 [mysql] Status change detected: running
18.07.19 [mysql] Status change detected: stopped
18.07.19 [mysql] Error: MySQL shutdown unexpectedly.
18.07.19 [mysql] This may be due to a blocked port, missing dependencies,
18.07.19 [mysql] improper privileges, a crash, or a shutdown by another method.
18.07.19 [mysql] Press the Logs button to view error logs and check
18.07.19 [mysql] the Windows Event Viewer for more clues
18.07.19 [mysql] If you need more help, copy and post this
18.07.19 [mysql] entire log window on the forums
mysql_error.log
- Code: Select all
InnoDB: using atomic writes.
2020-05-31 20:15:49 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-05-31 20:15:49 0 [Note] InnoDB: Uses event mutexes
2020-05-31 20:15:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-31 20:15:49 0 [Note] InnoDB: Number of pools: 1
2020-05-31 20:15:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-05-31 20:15:49 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-05-31 20:15:49 0 [Note] InnoDB: Completed initialization of buffer pool
2020-05-31 20:15:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2020-05-31 20:15:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-05-31 20:15:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-05-31 20:15:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-05-31 20:15:50 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-05-31 20:15:50 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-05-31 20:15:50 0 [Note] InnoDB: Waiting for purge to start
2020-05-31 20:15:50 0 [Note] InnoDB: 10.4.11 started; log sequence number 300297; transaction id 171
2020-05-31 20:15:50 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-05-31 20:15:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-05-31 20:15:50 0 [Note] InnoDB: Buffer pool(s) load completed at 200531 20:15:50
2020-05-31 20:15:50 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-06-01 9:15:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 9:15:02 0 [Note] InnoDB: Uses event mutexes
2020-06-01 9:15:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 9:15:02 0 [Note] InnoDB: Number of pools: 1
2020-06-01 9:15:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 9:15:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 9:15:02 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 9:15:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=384351
2020-06-01 9:15:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 9:15:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-06-01 9:15:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 9:15:03 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 9:15:03 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 9:15:03 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 9:15:04 0 [Note] InnoDB: 10.4.11 started; log sequence number 384360; transaction id 347
2020-06-01 9:15:04 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 9:15:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 9:15:04 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 9:15:04
2020-06-01 9:15:04 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-06-01 15:37:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 15:37:32 0 [Note] InnoDB: Uses event mutexes
2020-06-01 15:37:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 15:37:32 0 [Note] InnoDB: Number of pools: 1
2020-06-01 15:37:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 15:37:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 15:37:32 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 15:37:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=919247
2020-06-01 15:37:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 15:37:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-06-01 15:37:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 15:37:33 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 15:37:33 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 15:37:33 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 15:37:33 0 [Note] InnoDB: 10.4.11 started; log sequence number 919256; transaction id 1155
2020-06-01 15:37:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 15:37:33 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 15:37:33 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 15:37:33
2020-06-01 15:37:33 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-06-01 17:23:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:23:31 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:23:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:23:31 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:23:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:23:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:23:31 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:23:31 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1692826
2020-06-01 17:23:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:23:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-06-01 17:23:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:23:32 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:23:32 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:23:32 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:23:32 0 [Note] InnoDB: 10.4.11 started; log sequence number 1692835; transaction id 2094
2020-06-01 17:23:32 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 17:23:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:23:32 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 17:23:32
2020-06-01 17:23:32 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:23:32 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:23:32 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:23:32 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 17:24:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:24:00 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:24:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:24:00 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:24:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:24:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:24:00 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:24:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:24:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:24:00 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:24:00 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:24:00 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:24:00 0 [Note] InnoDB: 10.4.11 started; log sequence number 1692844; transaction id 2094
2020-06-01 17:24:00 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 17:24:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:24:00 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:24:00 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:24:00 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:24:00 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 17:28:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:28:30 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:28:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:28:30 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:28:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:28:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:28:30 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:28:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:28:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:28:31 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:28:31 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:28:31 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:28:31 0 [Note] InnoDB: 10.4.11 started; log sequence number 1692853; transaction id 2094
2020-06-01 17:28:31 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 17:28:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:28:31 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 17:28:31
2020-06-01 17:28:31 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:28:31 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:28:31 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:28:31 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 17:32:06 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2020-06-01 17:32:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:32:06 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:32:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:32:06 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:32:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:32:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:32:06 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:32:06 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2020-06-01 17:32:07 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibdata1' size is now 10 MB.
2020-06-01 17:32:07 0 [Note] InnoDB: Setting log file D:\Programmi\xamppRoot2\mysql\data\ib_logfile101 size to 5242880 bytes
2020-06-01 17:32:07 0 [Note] InnoDB: Setting log file D:\Programmi\xamppRoot2\mysql\data\ib_logfile1 size to 5242880 bytes
2020-06-01 17:32:07 0 [Note] InnoDB: Renaming log file D:\Programmi\xamppRoot2\mysql\data\ib_logfile101 to D:\Programmi\xamppRoot2\mysql\data\ib_logfile0
2020-06-01 17:32:07 0 [Note] InnoDB: New log files created, LSN=11452
2020-06-01 17:32:07 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2020-06-01 17:32:07 0 [Note] InnoDB: Doublewrite buffer created
2020-06-01 17:32:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:32:07 0 [Note] InnoDB: Creating foreign key constraint system tables.
2020-06-01 17:32:07 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2020-06-01 17:32:07 0 [Note] InnoDB: Creating sys_virtual system tables.
2020-06-01 17:32:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:32:07 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:32:07 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:32:07 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:32:07 0 [Note] InnoDB: 10.4.11 started; log sequence number 0; transaction id 7
2020-06-01 17:32:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:32:07 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:32:07 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:32:07 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:32:07 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 17:32:41 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:32:41 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:32:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:32:41 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:32:41 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:32:41 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:32:41 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:32:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:32:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:32:41 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:32:41 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:32:41 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:32:41 0 [Note] InnoDB: 10.4.11 started; log sequence number 47055; transaction id 9
2020-06-01 17:32:41 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 17:32:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:32:41 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 17:32:41
2020-06-01 17:32:41 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:32:41 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:32:41 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:32:41 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 17:35:48 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2020-06-01 17:35:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:35:48 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:35:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:35:48 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:35:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:35:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:35:48 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:35:48 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2020-06-01 17:35:48 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibdata1' size is now 10 MB.
2020-06-01 17:35:48 0 [Note] InnoDB: Setting log file D:\Programmi\xamppRoot2\mysql\data\ib_logfile101 size to 5242880 bytes
2020-06-01 17:35:48 0 [Note] InnoDB: Setting log file D:\Programmi\xamppRoot2\mysql\data\ib_logfile1 size to 5242880 bytes
2020-06-01 17:35:48 0 [Note] InnoDB: Renaming log file D:\Programmi\xamppRoot2\mysql\data\ib_logfile101 to D:\Programmi\xamppRoot2\mysql\data\ib_logfile0
2020-06-01 17:35:48 0 [Note] InnoDB: New log files created, LSN=11452
2020-06-01 17:35:48 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2020-06-01 17:35:48 0 [Note] InnoDB: Doublewrite buffer created
2020-06-01 17:35:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:35:48 0 [Note] InnoDB: Creating foreign key constraint system tables.
2020-06-01 17:35:48 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2020-06-01 17:35:48 0 [Note] InnoDB: Creating sys_virtual system tables.
2020-06-01 17:35:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:35:48 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:35:48 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:35:48 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:35:48 0 [Note] InnoDB: 10.4.11 started; log sequence number 0; transaction id 7
2020-06-01 17:35:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:35:48 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:35:48 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:35:48 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:35:48 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 17:42:08 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:42:08 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:42:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:42:08 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:42:08 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:42:08 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:42:08 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:42:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:42:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:42:08 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:42:08 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:42:08 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:42:08 0 [Note] InnoDB: 10.4.11 started; log sequence number 47055; transaction id 9
2020-06-01 17:42:08 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 17:42:08 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:42:08 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 17:42:08
2020-06-01 17:42:08 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:42:08 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:42:08 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:42:08 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 17:42:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:42:13 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:42:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:42:13 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:42:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:42:13 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:42:13 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:42:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:42:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:42:13 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:42:13 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:42:13 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:42:13 0 [Note] InnoDB: 10.4.11 started; log sequence number 47064; transaction id 9
2020-06-01 17:42:13 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 17:42:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:42:13 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 17:42:13
2020-06-01 17:42:13 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:42:13 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:42:13 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:42:13 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 17:42:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:42:16 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:42:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:42:16 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:42:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:42:16 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:42:16 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:42:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:42:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:42:16 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:42:16 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:42:16 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:42:16 0 [Note] InnoDB: 10.4.11 started; log sequence number 47073; transaction id 9
2020-06-01 17:42:16 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 17:42:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:42:16 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 17:42:16
2020-06-01 17:42:16 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:42:16 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:42:16 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:42:16 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 17:43:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:43:58 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:43:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:43:58 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:43:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:43:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:43:58 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:43:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:43:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:43:58 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:43:58 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:43:58 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:43:58 0 [Note] InnoDB: 10.4.11 started; log sequence number 47082; transaction id 9
2020-06-01 17:43:58 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 17:43:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:43:58 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 17:43:58
2020-06-01 17:43:58 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:43:58 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:43:58 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:43:58 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 17:47:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:47:30 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:47:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:47:30 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:47:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:47:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:47:30 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:47:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:47:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:47:30 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:47:30 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:47:30 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:47:30 0 [Note] InnoDB: 10.4.11 started; log sequence number 47091; transaction id 9
2020-06-01 17:47:30 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 17:47:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:47:30 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 17:47:30
2020-06-01 17:47:30 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:47:30 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:47:30 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:47:30 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 17:48:04 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 17:48:04 0 [Note] InnoDB: Uses event mutexes
2020-06-01 17:48:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 17:48:04 0 [Note] InnoDB: Number of pools: 1
2020-06-01 17:48:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 17:48:04 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 17:48:04 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 17:48:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 17:48:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 17:48:04 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 17:48:04 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 17:48:04 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 17:48:04 0 [Note] InnoDB: 10.4.11 started; log sequence number 47116; transaction id 9
2020-06-01 17:48:04 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 17:48:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 17:48:04 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 17:48:04
2020-06-01 17:48:04 0 [Note] Server socket created on IP: '::'.
2020-06-01 17:48:04 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 17:48:04 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 17:48:04 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-06-01 18:07:17 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-01 18:07:17 0 [Note] InnoDB: Uses event mutexes
2020-06-01 18:07:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-01 18:07:17 0 [Note] InnoDB: Number of pools: 1
2020-06-01 18:07:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-01 18:07:17 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-01 18:07:17 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-01 18:07:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-01 18:07:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-01 18:07:17 0 [Note] InnoDB: Setting file 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-01 18:07:17 0 [Note] InnoDB: File 'D:\Programmi\xamppRoot2\mysql\data\ibtmp1' size is now 12 MB.
2020-06-01 18:07:17 0 [Note] InnoDB: Waiting for purge to start
2020-06-01 18:07:17 0 [Note] InnoDB: 10.4.11 started; log sequence number 47125; transaction id 9
2020-06-01 18:07:17 0 [Note] InnoDB: Loading buffer pool(s) from D:\Programmi\xamppRoot2\mysql\data\ib_buffer_pool
2020-06-01 18:07:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-01 18:07:17 0 [Note] InnoDB: Buffer pool(s) load completed at 200601 18:07:17
2020-06-01 18:07:17 0 [Note] Server socket created on IP: '::'.
2020-06-01 18:07:17 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Di norma è consentito un solo utilizzo di ogni indirizzo di socket (protocollo/indirizzo di rete/porta).
2020-06-01 18:07:17 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-01 18:07:17 0 [ERROR] Aborting