Error starting MySQL in XAMPP

Navigation
1

I have installed XAMPP on a WINDOWS machine, but I get an error when starting it.

I have already uninstalled and installed twice, but the error keeps coming up. I opened the logdata and this is what appears to me:

  

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   ( link ) 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

     

2018-09-06 14:01:03 16b4 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.   2018-09-06 14:01:03 5812 [Note] InnoDB:   innodb_empty_free_list_algorithm has been changed to legacy because of   small buffer pool size In order to use backoff, increase buffer pool   at least up to 20MB.

     

2018-09-06 14:01:03 5812 [Note] InnoDB: Using mutexes to ref count   buffer pool pages 2018-09-06 14:01:03 5812 [Note] InnoDB: The InnoDB   memory heap is disabled 2018-09-06 14:01:03 5812 [Note] InnoDB:   Mutexes and rw_locks use Windows interlocked functions 2018-09-06   14:01:03 5812 [Note] InnoDB: _mm_lfence () and _mm_sfence () are used   for memory barrier 2018-09-06 14:01:03 5812 [Note] InnoDB: Compressed   tables use zlib 1.2.3 2018-09-06 14:01:03 5812 [Note] InnoDB: using   generic crc32 instructions 2018-09-06 14:01:03 5812 [Note] InnoDB:   Initializing buffer pool, size = 16.0M 2018-09-06 14:01:03 5812 [Note]   InnoDB: Completed initialization of buffer pool 2018-09-06 14:01:04   5812 [Note] InnoDB: Highest supported file format is Barracuda.   2018-09-06 14:01:04 5812 [Note] InnoDB: 128 rollback segment (s) are   active 2018-09-06 14:01:04 5812 [Note] InnoDB: Waiting for purge to   start 2018-09-06 14:01:04 5812 [Note] InnoDB: Percona XtraDB   ( link ) 5.6.38-83.0 started; log sequence number   1835037 2018-09-06 14:01:04 7352 [Note] InnoDB: Dumping buffer pool (s)   not yet started 2018-09-06 14:01:04 5812 [Note] Plugin 'FEEDBACK' is   disabled 2018-09-06 14:01:04 5812 [Note] Server socket created on IP:   '::'. 2018-09-06 14:01:04 5812 [ERROR] Can not start server: Bind on   TCP / IP port. Got error: 10048: Only one usage of each socket address   (protocol / network address / port) is normally permitted.

     

2018-09-06 14:01:04 5812 [ERROR] Do you already have another mysqld   server running on port: 3306? 2018-09-06 14:01:04 5812 [ERROR]   Aborting

On the machine there is another instance, but of an application that connects to a MySQL database. But I can not uninstall it, so how do I change the MySQL XAMPP port or what should I do?

Someone who has experienced a similar problem?

    
asked by Jose Daniel Solis 06.09.2018 в 22:30
source

1 answer

2

When you have a previous installation of MySQL on the same machine that you can not install because other applications access it, you must follow the following procedure to get install both with different ports:

  • Rename the original MySQL service (to avoid being overwritten by XAMPP) by navigating in the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services register looking for the subkey with the name MySQL , MySQL server or similar. Press the right button and Renombrar to change the name to MySQL_original to give an example. You can back up the branch before making the changes.
  • Check in services.msc that the service has changed its name correctly and that it starts correctly after restarting the machine.
  • Before installing XAMPP to stop the original MySQL service (temporarily, only during the XAMPP installation process).
  • Perform the installation of XAMPP.
  • Start the XAMPP control panel as administrator ( XAMPP > XAMPP Control Panel by right clicking and Ejecutar como administrador ).
  • Press the button Config of the row corresponding to MySQL .
  • In the file my.cnf open search under the tag [mysqld] the parameter port = 3306 to change it for any other port, for example port = 3307 .
  • Restart the service by clicking on Stop and then Start in the XAMPP control panel or in services.msc .
  • Start the original MySQL service and check that it starts correctly.
  • Restart the machine to verify that the changes are maintained after the restart without any conflict.

Now you can connect to both instances by the following ports:

  • 3306: Original MySQL
  • 3307: MySQL installed by XAMPP
answered by 07.09.2018 в 09:52
Store date and time in variable in a MySQL stored procedure How to apply str_pad correctly to a string that has asentos