MySQL (xampp) not working.

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL (xampp) not working.

Postby panasalsa » 28. November 2014 23:11

I can not get the MySQL to run. Apache is working after I change the port from 80 to 8080. however now I notice mysql is not opening. I have this set on portableapp. on my USB.
currently my ports are as follow;
Apache 8080 main and ssl 336
MySQL ini is 3306 every thing is default but the main apache port 80 which I changed to 8080.
I also have xampp on my C: drive and apache and mysql are working good. (not under portableApps on C:drive).
I also tried to uninstalled mysql on the control panel and does not let me do it.

4:56:43 PM [mysql] Problem detected!
4:56:43 PM [mysql] Port 3306 in use by "C:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql"!
4:56:43 PM [mysql] MySQL WILL NOT start without the configured ports free!
4:56:43 PM [mysql] You need to uninstall/disable/reconfigure the blocking application
4:56:43 PM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
4:56:43 PM [mysql] Attempting to start MySQL service...
4:56:47 PM [mysql] Uninstalling service...
4:56:47 PM [mysql] MySQL Service detected with wrong path
4:56:47 PM [mysql] Change XAMPP MySQL and Control Panel settings or
4:56:47 PM [mysql] Uninstall/disable the other service manually first
4:56:47 PM [mysql] Found Path: C:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql
4:56:47 PM [mysql] Expected Path: e:\xampp\mysql\bin\mysqld.exe --defaults-file=e:\xampp\mysql\bin\my.ini mysql
4:56:47 PM [mysql] Service was NOT (un)installed!

Can you suggest what ports i should have in both systems; on the C:drive and USB? ( when I set up my xampp on my C:drive I was force to change the ports too because it said, my sistem was using port 80)
Posts: 2
Joined: 21. November 2014 20:08
Operating System: windows 8.1

Re: MySQL (xampp) not working.

Postby Altrea » 28. November 2014 23:46

panasalsa wrote:I also have xampp on my C: drive and apache and mysql are working good. (not under portableApps on C:drive).

And thats the problem. MySQL in C is already running on that port.
Because you have registered MySQL on C as Windows service it gets startet on system boot.
And because both XAMPP MySQL components are trying to use the same service (same servicename) you now have the problems.

If you would change the expected servicename for the portable MySQL component, you would be able to start MySQL if your MySQL on C is not running at the same time
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
AF Moderator
Posts: 8248
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL (xampp) not working.

Postby 1bava » 29. November 2014 16:28

Guys, I am not sure what this means.

2014-11-29 12:46:35 5100 [Note] Plugin 'FEDERATED' is disabled.
2014-11-29 12:46:35 17fc 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.
2014-11-29 12:46:35 5100 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-29 12:46:35 5100 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-29 12:46:35 5100 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-29 12:46:35 5100 [Note] InnoDB: Memory barrier is not used
2014-11-29 12:46:35 5100 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-29 12:46:35 5100 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-29 12:46:35 5100 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-11-29 12:46:35 5100 [Note] InnoDB: Completed initialization of buffer pool
2014-11-29 12:46:35 5100 [Note] InnoDB: Highest supported file format is Barracuda.
2014-11-29 12:46:36 5100 [Note] InnoDB: 128 rollback segment(s) are active.
2014-11-29 12:46:37 5100 [Note] InnoDB: Waiting for purge to start
2014-11-29 12:46:37 5100 [Note] InnoDB: 5.6.21 started; log sequence number 1665234
2014-11-29 12:46:37 5100 [Note] Server hostname (bind-address): '*'; port: 3306
2014-11-29 12:46:37 5100 [Note] IPv6 is available.
2014-11-29 12:46:37 5100 [Note] - '::' resolves to '::';
2014-11-29 12:46:37 5100 [Note] Server socket created on IP: '::'.
2014-11-29 12:46:37 5100 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-11-29 12:46:37 5100 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-11-29 12:46:37 5100 [ERROR] Aborting
Posts: 1
Joined: 29. November 2014 14:41
Operating System: Windows

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 49 guests