MySQL 데이터베이스가 XAMPP Manager-osx에서 시작되지 않습니다.

MySQL 데이터베이스가 XAMPP Manager-osx에서 시작되지 않습니다.

---

한 달 전에 XAMPP를 다운로드했는데 제대로 작동했습니다. 오늘 저는 음성 인식 소프트웨어를 설치 한 다음 컴퓨터를 다시 시작했습니다. 그 이후로 MySQL은 내 manager-osx 애플리케이션에서 시작되지 않습니다. 응용 프로그램 로그에 나를 던지지 않습니다. 이것이 말하는 내용입니다.

Stopping all servers...
Stopping Apache Web Server...
/Applications/XAMPP/xamppfiles/apache2/scripts/ctl.sh : httpd stopped
Stopping ProFTPD...
Checking syntax of configuration file
/Applications/XAMPP/xamppfiles/proftpd/scripts/ctl.sh : proftpd stopped
Restarting all servers...
Starting MySQL Database...

Starting Apache Web Server...
/Applications/XAMPP/xamppfiles/apache2/scripts/ctl.sh : httpd started
Starting ProFTPD...
Checking syntax of configuration file
/Applications/XAMPP/xamppfiles/proftpd/scripts/ctl.sh : proftpd started

내 ProFTPD와 Apache Web Server가 모두 실행 중입니다. MySQL은 그렇지 않습니다. phpmyadmin으로 이동하면이 오류 메시지가 표시됩니다.

#2002 - No such file or directory
The server is not responding (or the local server's socket is not correctly configured).

제발 도와주세요. 어떻게해야할지 모르겠습니다.

최신 정보:

인터넷을 조금 둘러 본 후, 사용자가 MAMP에서 겪은 비슷한 문제를 발견했습니다. 다른 사용자는 mysql 프로세스를 죽 이도록 권장했습니다. 이것이 내 문제를 해결할 수 있습니까?

업데이트 2 :

내 문제에 대한 답을 찾았지만 아직 답할 수 없습니다. 그래서 여기에 답이 있습니다.

1) 터미널 열기 및 유형

sudo su

그런 다음 암호를 입력하십시오

2) 그런 다음 입력

ps aux | grep mysql

(복사하여 붙여 넣기)

3) mysql의 프로세스 ID를 얻어야합니다. 상단 근처에 739 또는 8827과 같이 숫자가 있어야합니다.

4) 다음을 사용하여 프로세스를 종료하십시오.

kill -9 {process id}

이것은 다음과 같이 보일 것입니다 : kill -9 739

5) manager-osx에서 MySQL 다시 시작

---

이것은 작동합니다.
sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

---

최소 가이드

1. sudo killall mysqld

2. manager-osx> mysql 시작

---

작동하지 않으면 ...

sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

Google 오류 ...

---

예 :

오류:

ERROR! The server quit without updating PID file (/Applications/XAMPP/xamppfiles/var/mysql/<computername>.local.pid)

내 솔루션 :

에서 /Applications/XAMPP/xamppfiles/etc/my.cnf변경 user = <uid>이 s에 <uid>있습니다 uid에서 id명령.

$ id
uid=...

$ vim /Applications/XAMPP/xamppfiles/etc/my.cnf
...

---

이러한 명령이 작동하지 않는 경우 :

sudo killall mysqld
sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

이 시도:

XAMPP 7.1.1-0의 경우 포트 번호를 3306에서 3307로 변경했습니다.

1. 서버 관리를 클릭하십시오.
2. MySQL 데이터베이스 선택
3. 오른쪽의 구성 을 클릭하십시오.
4. 포트 번호를 3307로 변경하십시오.
5. 확인 클릭
6. Close your Control Panel and relaunch it.

You are now good to go.

---

check the err log on your /Applications/XAMPP/xamppfiles/var/mysql/ with filename like your_machine_name.local.err, if you find something like: "Attempted to open a previously opened tablespace. Previous tablespace ... uses space ID"

the following works for me:

edit file:

/Applications/XAMPP/xamppfiles/etc/my.cnf

find the [mysqld] section, add one line:

innodb_force_recovery = 1

then run

sudo /Applications/XAMPP/bin/mysql.server start

everything is ok again.

and then the last step:

edit the my.cnf again and remove the line you just added :

innodb_force_recovery = 1

and restart mysql again. Otherwise all your tables will be read only

---

I've tried all these methods with no luck (including of course rebooting) but when I

sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

I simply get:

Starting MySQL
. ERROR! 

Not exactly the most helpful information!

---

For me the following worked: Change permission into 'read only' for 'everyone' to the file /Applications/XAMPP/xamppfiles/etc/my.cnf. Then start MySQL from XAMPP manager.

---

I first couldn't manage to kill mysql daemon with the commands posted here. So I remembered my linux times and did the following:

I monitored the running processes by running top in one terminal window. Then I killed mysqld via sudo killall mysqld (screw the PID ;-) ) in another and restarted via sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start.

---

1. close XAMPP control
2. sudo killall mysqld
3. sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

---

it happened to me. and

sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

not work for me.

so, i reinstall the xampp, then fix it.

attention:

reinstall the xampp, will not delete mysql data, no need to worry about that.

---

Try running these two commands in the terminal:

1. sudo killall mysqld sudo
2. /Applications/XAMPP/xamppfiles/bin/mysql.server start

---

There's been a lot of answer, but I think I found what is causing it, at least for me. It looks like if you put your computer to sleep (or it falls asleep on its own), when it reopens, it tries to open the the mysql process again. At one point I looked at my activity monitor and I had 5 instances running - killing all of them and then starting mysql works.

---

sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start    

This worked for me.

---

I had success with easy killing all active mysql processes in Monitor Activity tool:

1) close XAMPP control

2) open Monitor Activity

3) select filter for All processes (default is My processes)

4) search for: mysql

5) force quit all the mysql

6) relaunch XAMPP control and launch apache again

Enjoy

---

try these two line from terminal

1. sudo killall mysqld
2. sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

---

It can cause because of the software you installed or may be any other software which is using the same port 3306. This 3306 port is used by the Mysql in XAMPP. Similar kind of problem I faced for Apache. I was running skype and trying to run the XAMPP but the skype uses the same port as Apache so it was not working. Then I sign out from skype then the port was free and the apache started. So you should look for the software in you laptop which is blocking or making busy this port. Free that port by closing the software and then run XAMPP and It will work.

---

What I did was the following: In XAMPP Control Panel I edited the my.ini file of configuration of MySql and changed the port from 3306 to 3307 and it worked, hope it helped!

Edit: after you save this changes be sure that the service is off and then restart the service. I had this same problem when I installed MySQL, it's just the port.

---

I encountered this problem just now. I checked log file and found it is caused by the server was not shutdown correctly. So I found this http://rivenlinux.info/how-to-recover-innodb-corruption-for-mysql/ and add a simple configuration "innodb_force_recovery = 1" in [mysqld] in my.cnf. Then the problem was solved.

The log file is located /Applications/XAMPP/xamppfiles/var/mysql and it named accroding to your server name. Just link this XXX-MacBook-Pro.local.err

---

All the answers stated above in relation to changing the port number are in this situation the best way to solve this problem since you need your voice recognition software to coexist with MAMP. However, you must remember that changing this port number is going to affect all you subsequent connections to MySQL (i.e, terminal,php code,phpmyadmin,etc). Hence It would be advisable to change the port on which the voice recognition software runs. Hope this was helpful.

:)

---

if you are getting this error

.............ERROR! The server quit without updating PID file 

Try this

Go to /Applications/XAMPP/xamppfiles/var/mysql/

if there is no file with the name Your_Username.local.pid

Your_Username should replace with your Mac Username

Create a file with this name

Then try

sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start    

its worked for me

---

It had the same problem, all I did was give read-only permissions for ALL users (system included) and all items included in the following folders:

/Applications/XAMPP/xamppfiles/etc
/Applications/XAMPP/xamppfiles/sbin

and relaunch XAMPP control and launch mysql server again or

sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start   

---

This could be due to the fact that another instance of mysqd is already running in your mac-book-pro (MacOs-10). It's next to impossible to kill/pkill mysqld or ....I tried that route many times, with out any success. Finally the following worked for me :

launchctl unload -w /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

wait a few minutes and check with

ps -ef|grep mysqld

It should be gone!

---

on

macOs High Sierra

if mysql is not getting started from manager- oxs and have tried direct command i.e

sudo /Applications/XAMPP/bin/mysql.server start

too than go to path edit

/Applications/XAMPP/xamppfiles/etc/

find file :

my.cnf

edit it

under the [mysqld] section, add following line:

innodb_force_recovery = 1

after it save and run or can be done from manager-osx

sudo /Applications/XAMPP/bin/mysql.server start

it should start the mysql.

once its run you need to again edit the

my.cnf

file and remove the line just added

innodb_force_recovery = 1

stop and start mysql again. by command

sudo /Applications/XAMPP/bin/mysql.server start 

or by manager-osx

it will be working fine.

---

It might be the possibility that your voice recognition software has a installer of mysql internally and when u installed this software, it has installed mysql too and added it to the service and this mysql service starts once your system starts. So now u r having two mysql servers (one from voice recognition software and second is from XAMPP) that's why killing the previous process (mysql service) solved your problem. But this is not a permanent solution, you have to repeat it every time when ever you start your machine. So better is to find out that mysql server (service) and change its port no. OR change settings so that mysql service should not start when your machine start (but might be your voice recognition software won't work properly)

I hope it will help you.

Cheers

---

You seem to have found a work-around by killing the process, but make sure you check for free space on your MySQL partition. If your logs or db files are consuming all your drive space, mysqld will not start.

---

Restarting the computer, or using the 'kill' commands listed above solve the problem. AS for preventing it from happening, I've found this occurring anytime my computer goes to sleep. The port is obviously kept reserved, and then on wake, mysql tries to reconnect to that port, but can't. This could be your problem also.

---

I am running XAMPP 5.6.3-0 for OS X Yosemite 10.10.2 and ran into the same issue twice, the first time was with Mavericks. With a bunch of different solutions to the issue with MySQL Database not starting using Manager App I wanted to confirm what had worked for me. The workaround that always worked and forced MySQL to start was by opening Terminal and using: sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start I had the Manager App open and started ProFTPD and Apache and then ran the sudo command.

The other suggestion by wishap that worked was to locate /Applications/XAMPP/xamppfiles/etc/my.cnf file and change the permissions for "everyone" to Read only.

The other problem I had that seems to be another issue with many solutions is the problem after everything is started then entering localhost which brings me to the xampp splash screen and then nothing. The only thing that worked for me, to at the very least, to access the phpMyAdmin page is by entering localhost/phpmyadmin

I hope this helps others reading through a bunch of threads for an answer.

Regards, Erik

---

Try this, sudo service mysql stop it will stop any other mysql services and then restart xampp

---

Just Click on Managed Servers Tab in XAMPP MANAGER , Now select MySQL Database, Click on configure on right side.

Change port from 3306 to 3307 and it will work.

---

It had the same problem, all I did was give read-only permissions for all users and all items included in the following folders:

/Applications/XAMPP/xamppfiles/etc
/Applications/XAMPP/xamppfiles/sbin

---

Well, sometime there is just ERROR! message is shown in mysql comment on terminal. Then, just reinstall (overwrite) XAMPP, then it can be solved.

참고URL : https://stackoverflow.com/questions/21267064/mysql-database-wont-start-in-xampp-manager-osx