I started MySQL with its PrefPane in System Preferences:
When I enter
ps aux | grep mysql I get the following output:
But how do I know which port MySQL is using on my Mac? Entering klanomath
lsof -i tcp:3306 I find nothing.
50.7k77 gold badges7676 silver badges144144 bronze badges
aircraftaircraft
79022 gold badges77 silver badges2525 bronze badges
3 Answers
There are a few options:
You can list the ports that are being 'listened on' with
netstat
(I only run MySQL on VMs so it won't show up on my Mac, but this illustrates the output)
You can also just look and see what port is configured for MySQL to use by examining the AllanAllan
/etc/my.cnf file. Under the [mysqld] section.
47k1616 gold badges7575 silver badges182182 bronze badges
If you have turned on Apache on your Mac and also enabled PHP, you can run the
phpinfo() command which will give you tons of information such as:
Based on what I've read, 3306 is the default, so if you didn't specifically change it, then it's probably that.
You can also use MySQL Workbench from Oracle. When I launch it, it shows:
Allan
47k1616 gold badges7575 silver badges182182 bronze badges
Zonker.in.GenevaZonker.in.Geneva
Assuming that mysql is on your $PATH then in the terminal:
Mark
20.6k1111 gold badges5858 silver badges9797 bronze badges
Samer s SalibSamer s Salib
You must log in to answer this question.Not the answer you're looking for? Browse other questions tagged macmysql .
Error after downloading MySQL server and mysql for visual studio
Edit: Now it says Attempting to start MySQL app.. and then it keeps loading and won't open after switching port to 3307
user7409907
2 Answers
This is probably an easier fix:
1) Open Commandline -> type: 'netstat -aon'
2) Check out the PID on port 3306
Power data recovery 4.1.1 full. 3) Go to Task Manager and stop the process with that PID
4) Restart XAMPP and retry MySQL
Siebrand RomeynSiebrand Romeyn
code:
and here also
Code:
SdpSdp
Posted by2 years ago
Archived
the output when it is on port 3306
9:44:05 AM [mysql] Problem detected!
9:44:05 AM [mysql] Port 3306 in use by 'C:UsersAdministratorDownloadsmysql-5.7.13-winx64mysql-5.7.13-winx64binmysqld mysql2'!
9:44:05 AM [mysql] MySQL WILL NOT start without the configured ports free! 9:44:05 AM [mysql] You need to uninstall/disable/reconfigure the blocking application
9:44:05 AM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
9:44:05 AM [mysql] Attempting to start MySQL service..
after changing the port number in my.ini from 3306 to 3307 and the httpq.conf localhost from 80 to 442, mysql did not want to start up. I read things online saying that using command 'sc delete mysql' to delete the current mysql that is installed.
would 'sc delete mysql' delete any of the data stored? It was working fine before we had a power outage it just stopped working.
after changing the port number in the control panel, i get this
10:09:36 AM [mysql] MySQL Service detected with wrong path
10:09:36 AM [mysql] Change XAMPP MySQL and Control Panel settings or
10:09:36 AM [mysql] Uninstall/disable the other service manually first
10:09:36 AM [mysql] Found Path: C:xamppmysqlbinmysqld MySQL
10:09:36 AM [mysql] Expected Path: c:xamppmysqlbinmysqld.exe --defaults-file=c:xamppmysqlbinmy.ini mysql
IF ANYONE HAS ANY SUGGESTIONS OR IDEAS PLEASE PLEASE LET ME KNOW. IM TRYING TO FIX A SERVER AT WORK. AND NO ONE HERE HAS A CLUE.
then after that, I went into xampp and deleted the mysql from module service and reinstall it.
then i went into C:xamppmysqldata directory and deleted ibdata1 and all the ib_logfile changed the port from 3306 to 3307 on the xampp control panel and also in the ini.my file. found all my backup file that was stored C:.mysqldatabackup to the current place where my data is stored now. after that, it worked like a charm and all my data is restored. I hope this will help someone from going through some trouble.
12 comments
I installed Xampp on Windows 7 32-bit. When I try to start MySql in XAMPP control panel (v3.2.1) I have the following message and MySql does not start.
A similar problem was reported here but there is no working answer. When I try to install with MySql disabled, the result is that I even don't have an option even to try to run it.
I am new to Xampp and don't know where and what to look for to solve the issue
I need to run Apache and MySql with Php.
Community♦
tomasz74tomasz74
5,25788 gold badges2727 silver badges4242 bronze badges
8 Answers
You already have a version of mySQL installed on this machine that is using port 3306. Go into the most recent
my.ini file and change the port to 3307 . Restart the mySQL service and see if it comes up.
You also need to change port 3306 to 3307 in xamppphpphp.ini
Community♦
DevlshOneDevlshOne
7,24211 gold badge2222 silver badges3232 bronze badges
You have two versions of mysql using the same port. 3306.Change the port.
How to change the mysql port for xampp?
Code:
and here also
Code:
John HoganJohn Hogan
67911 gold badge1010 silver badges2222 bronze badges
I found out that re-installing Xampp as an administrator and running it as an Administrator worked.
Gideon MwangiGideon Mwangi
If there are two instances of MySql it's normal that it gives such an error if they both run at the same time. If you really need 2 servers, you must change the listening port of one of them, or if you don't it's probably better to simply uninstall one of them. This is so regarless of MySql itself, because two programs cannot listen on the same port at the same time.
AlejandroAlejandro
4,45222 gold badges2424 silver badges3939 bronze badges
Try this: really quick + worked for me:
ps: excuse image below for different language :)
DBSDBS
Same issue on macOS and got it fixed by running the same installer again.
Whereas I COULD NOT get it fixed by
Note:Make sure to select 'XAMPP Core Files' component while running the installer as by default it is not selected.
Though re-running the installer is not smart option when one has to do it every now and then. My installer is xampp-osx-7.0.13-1-installer.dmg
Update: I've got my MAMP working with this simple solution here. So, same should work for XAMPP.
zeeawanzeeawan
4,49211 gold badge3939 silver badges4343 bronze badges
Port 3306 In Use By Unable To Get Information
If you have previously installed MySQL Workbench the problem is that another MySQL instance is running at 3306 port.
So uninstall MySQL and XAMPP and after that, reinstall only XAMPP.
This worked for me.
Sergio GandrusSergio Gandrus
Google Brings me here. The favourite answers don't help me.I've now solved it, so maybe this will help someone else.Problem: after UPDATE of XAMPP to a new version I get the message 'MySQL WILL NOT start without the configured ports free!'.
However, I only have 1 instance of mysqld running.
It seems that the control panel is not as clever as it looks. As far as I can tell, the single instance of mysqld is the new one i've just updated to, but running as a 'service'. The control panel then tries to start it, and instead of realising its already running, It assumes its another service and reports the error.
Probable cause: The uninstaller failed to remove the autostart property from the mysql service, so the new instal picked it up.
How To Free Port 3306 For Mysql
Solution:
open the Xammpp Control Panel and click on the Services Button on the right. This will open the services control panel.Look for mysqld in the list of running processes, right-click it to get the properties and change the startup type to 'Manual'.you might as well do the same for Apache2 while you're here.Apply changes and Close the services control panel. Port 3306 Is Not Found Associated With Tcp Protocol
Now click the Config Button on xampp control panel, uncheck The Mysql (and Apache) Autostart features.
Reboot the machine.You should now be able to start / stop Mysql & Apache without any error messages.If this works, use the Xampp Control panel as usual to start/stop add service or add autostart as normal.No need to mess with any ports or config files.
jcanselljcansell
protected by Community♦Nov 13 '14 at 19:53
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead? Not the answer you're looking for? Browse other questions tagged mysqlxampp or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |