I have uninstalled both of them, XAMPP and HeidiSQL and installed them again. The error message is:Ĭan't connect to MySQL server on '127.0.0.1' (10061) Not only XAMPP, I can't even get a connection with HeidiSQL.
Step 2: The mac and PC version of this page may look different but both have the same link under the MySQL section in the middle. Click on the middle button to bring up the Start Page. I have tried all answers from that questions but none of them worked for me. Step 1: Start MAMP which will display this window. Click Open WebStart page and see if PHPMyAdmin opens. Under the 'Ports' tab, click the 'Set Web & MySQL ports to 80 & 3306' button. Version: '10.3.16-MariaDB' socket: '' port: 3307 binary distribution Hey Greg, Not sure itll help because this sounds like a unique configuration problem, but here are some things I would try: Go to MAMPs Preferences (with the app open, its under 'MAMP' in the top bar). 1:18:11 0 mysql\bin\mysqld.exe: ready for connections. 1:18:11 0 Added new Master_info '' to hash table 1:18:11 0 Reading of all Master_info entries succeeded 1:18:11 0 Server socket created on IP: '::'. 1:18:11 0 Plugin 'FEEDBACK' is disabled. 1:18:11 0 InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool 1:18:11 0 InnoDB: Waiting for purge to start 1:18:11 0 InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
Physically writing the file full Please wait. 1:18:11 0 InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. 1:18:11 0 InnoDB: Creating shared tablespace for temporary tables 1:18:11 0 InnoDB: Removed temporary tablespace data file: "ibtmp1"
1:18:11 0 InnoDB: 128 out of 128 rollback segments are active. 1:18:11 0 InnoDB: Starting crash recovery from checkpoint LSN=1791378 1:18:11 0 InnoDB: Completed initialization of buffer pool 1:18:11 0 InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 1:18:11 0 InnoDB: Using SSE2 crc32 instructions 1:18:11 0 InnoDB: Compressed tables use zlib 1.2.11
Mysql_error.log: 1:18:11 0 InnoDB: Mutexes and rw_locks use Windows interlocked functions Plugin-dir=C:/Program Files/MariaDB 10.3/lib/plugin I know that both of them use the same port (3306) and I have tried to change the port of MariaDB to 3308.ĭatadir=C:/Program Files/MariaDB 10.3/data The problem may be, because I have also installed HeidiSQL, which comes with MariaDB. So if I click on "Start", I get the message " 01:26:41 Attempting to start MySQL service." and that's it. Albeit without any databases, hosts or settings.I cannot start MySQL with XAMPP and I do not get any errors.
I then did a system restart, re-installed MAMP Pro completely fresh, and it all worked first time. looking at permissions and ownership, the app and files were owned by root (but not sure that had any refection on the gave me pointers to the uninstaller (something I didn't know existed), which due to permissions couldn't actually do anything. Also, although I could change the settings on the MAMP interface, none would save. MySQL was running but Apache couldn't launch. I've also tried booting into Safe mode, then restarting (another suggested solution).ĭue to trying to get my local server up and running again, I installed and got working XAMPP, which then had a knock on effect of allowing MAMP Pro to display a decent error message (instead of continually working) and allow the options on the interface to be active again.
I've used Cocktail to purge memory cache and rebuild launch Services database.
I run: ps aux | grep mysqld in terminal (as suggested on numerous sites as a solution to MAMP Pro not starting MySQL), it lists one entry, but the PID continually increases and I can't kill the process via the name mysqld. 18:35:22.335 WindowServer: įailed setting the front application to System Preferences, psnĠx0-0x23023, securitySessionID=0x186a5, err=-13066 Preferences" 0x0x7fde9ad13050 tried to be broughtįorward, but isn't in fPermittedFrontASNs ( ( ASN:0x0-0x22022:) ), so 18:35:22.335 coreservicesd: Application App:"System I've updated MAMP Pro to latest version (v2.1.2), and Googled for solutions, nothing seems to resolve it. I did a restart, both those apps were then fine, but MAMP Pro fails to launch. I'm running OSX v10.8.2 and Path Finder crashed, followed by Skype.
I try to launch MAMP Pro, enter my system password then it sits there trying to connect to MySQL.