Ho appena installato xampp sul mio Mac OS x. Quando ho provato ad avviare mysql visualizza un messaggio che mysql is already running on this computer. In order to start mysql stop first mysql
. Ho provato a seguire modi per fermarlo, ma nessuno dei due funziona.
mysqladmin version
sudo /usr/local/mysql/mysql.server stop //mysql.server command not found
mysqladmin -u root -p password shutdown //restarts the server but not shutdown
quando uso il comando which mysql
mostra questo percorso
/usr/local/bin/mysql
e quando invio il comando ps aux | grep mysqld
ottengo l'output seguente
zafarsaleem 85209 0.0 0.3 2699804 13204 ?? S 7:51AM 0:00.88 /Applications/MAMP/Library/bin/mysqld --basedir=/Applications/MAMP/Library --datadir=/Applications/MAMP/db/mysql --plugin-dir=/Applications/MAMP/Library/lib/plugin --lower-case-table-names=0 --log-error=/Applications/MAMP/logs/mysql_error_log.err --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --socket=/Applications/MAMP/tmp/mysql/mysql.sock --port=8889
zafarsaleem 85093 0.0 0.0 2435488 924 ?? S 7:51AM 0:00.03 /bin/sh /Applications/MAMP/Library/bin/mysqld_safe --port=8889 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --lower_case_table_names=0 --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --log-error=/Applications/MAMP/logs/mysql_error_log
zafarsaleem 86693 0.0 0.0 2425480 180 s004 R+ 8:30AM 0:00.00 grep mysqld
zafarsaleem 86507 0.0 0.3 2678756 11364 ?? S 8:07AM 0:00.63 /usr/local/Cellar/mysql/5.5.20/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.5.20 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.5.20/lib/plugin --max-allowed-packet=32M --log-error=/usr/local/var/mysql/Zafars-MacBook-Pro-2.local.err --pid-file=/usr/local/var/mysql/Zafars-MacBook-Pro-2.local.pid
zafarsaleem 86447 0.0 0.0 2435488 920 ?? S 8:07AM 0:00.02 /bin/sh /usr/local/bin/mysqld_safe --max_allowed_packet=32M
Come posso risolvere questo problema?
Aggiorna
Quando rilascio questo comando launchctl list
, allora vedo mysqld nell'elenco come segue
com.apple.AddressBook.SourceSync
- 0 com.apple.AddressBook.abd
1201 - homebrew.mxcl.mysql <--
443 - homebrew.mxcl.mongodb
- 0 com.google.keystone.user.agent
- 0 com.adobe.ARM.df0ab5bbe6f698196fcc21e3c1e66dcb758bd911f4d637272d9d8109
- 0 com.adobe.AAM.Scheduler-1.0
45 - 0x7fd1bba073e0.anonymous.loginwindow
- 1 com.apple.launchctl.Aqua
1261 - 0x7fd1bba0c6e0.anonymous.mysqld <--
212 - 0x7fd1ba5206d0.anonymous.launchd
230 - 0x7fd1ba5203d0.anonymous.Terminal
In secondo luogo quando ho tentato di emettere il comando di sotto come menzionato da @PunjCoder
sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql.plist
OUTPUT for above is:
launchctl: Couldn't stat("/Library/LaunchDaemons/org.macports.mysql.plist"): No such file or directory
nothing found to unload
sudo launchctl unload -w /System/Library/LaunchDaemons/org.macports.mysql.plist
OUTPUT for above is:
launchctl: Couldn't stat("/System/Library/LaunchDaemons/org.macports.mysql.plist"): No such file or directory
nothing found to unload
Quindi cosa posso fare per fermarli e come? Sono molto nuovo a mac os x quindi non so davvero come risolvere questo problema. Per favore aiuto ...