MySQL Server will not start

Report any found bug here. We are grateful for any useful clues.

Moderator: severin

wsday
Posts: 3
Joined: Tue 5. Feb 2008, 11:16

MySQL Server will not start

Post by wsday » Wed 16. Apr 2008, 10:24

- Installed MAMP on my 10.5.2 system, in Applications folder
- Put the widget in ~/Library/Widgets
- Put my html and php content into htdocs
- Clicked Start Servers on the widget, after 12 hours, the cursor is still spinning
- Opened MAMP, clicked Start Servers. Apache Server is green, MySQL red
- Opened Preferences, changed Ports using Set to default. Apache still green, MySQL still red
- Opened Preferences, changed Ports using Reset MAMP ports. Apache still green, MySQL still red
- tried the fix noted on other posts, to Open Preferences and just hit OK, with both port settings. No change. Apache green, MySQL red
- Quit and restart MAMP. No change.
- Delete widget. Reinstall. No change.
How do I get MySQL Server to start?

severin
Posts: 225
Joined: Thu 8. Mar 2007, 08:03
Location: Germany

Post by severin » Wed 16. Apr 2008, 14:05

Hi wsday,

do you see any errors in mysql_error_log or in the general Console log?

Thanks,

Severin Kurpiers
living-e AG

wsday
Posts: 3
Joined: Tue 5. Feb 2008, 11:16

my_sql_error_log and system.log

Post by wsday » Wed 16. Apr 2008, 21:06

There are repeated instances of:

080416 05:23:45 mysqld started
080416 5:23:45 [Warning] Can't create test file /var/lib/mysql/Gumby.lower-test
080416 5:23:45 [Warning] Can't create test file /var/lib/mysql/Gumby.lower-test
/Applications/MAMP/Library/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13)
080416 5:23:45 [ERROR] Aborting

080416 5:23:45 [Note] /Applications/MAMP/Library/libexec/mysqld: Shutdown complete

080416 05:23:45 mysqld ended

system.log shows:
Apr 16 05:23:45 Gumby [0x0-0x13d13d].com.living-e.MAMP[38683]: chown: /Applications/MAMP/logs/mysql_error_log: Operation not permitted
Apr 16 05:23:45 Gumby [0x0-0x13d13d].com.living-e.MAMP[38683]: Starting mysqld daemon with databases from /var/lib/mysql
Apr 16 05:23:45 Gumby [0x0-0x13d13d].com.living-e.MAMP[38683]: STOPPING server from pid file /Applications/MAMP/tmp/mysql/mysql.pid
Apr 16 05:23:45 Gumby [0x0-0x13d13d].com.living-e.MAMP[38683]: 080416 05:23:45 mysqld ended

wsday
Posts: 3
Joined: Tue 5. Feb 2008, 11:16

Re: MySQL Server will not start

Post by wsday » Thu 24. Apr 2008, 10:47

Hi severin,
Do you need something additional to figure out what is wrong? If so, please ask and I will be happy to provide it. I would greatly appreciate some guidance on how to fix this problem, so I can move forward.
Thx,

severin
Posts: 225
Joined: Thu 8. Mar 2007, 08:03
Location: Germany

Re: MySQL Server will not start

Post by severin » Tue 29. Apr 2008, 15:00

Hi wsday,

I guess that you have another installation of mysql and MAMP's mysql is getting confused by the other my.cnf file. Do you still need it? Can you find it and try to rename it to see if the problem persists?

Thanks,

Severin Kurpiers
living-e AG

dstranathan
Posts: 3
Joined: Thu 26. Mar 2009, 13:53

Re: MySQL Server will not start

Post by dstranathan » Thu 26. Mar 2009, 14:04

I have seen the EXACT same issues with my installation too. Running Mac OS X 10.5.6 (not the server version). Intel Mac mini 1 GB RAM. Apache starts, but MySQL won't start. This system doesnt have any other conflicting installations of MySQL. No port conflicts. Tried various ports. No PID file is ever created. Cant change MySQL root password. I will post MySQL and Mac OS X logs here.

Its March 26th 2009. Nobody has a solution yet?

sedmonds
Posts: 3
Joined: Fri 11. Dec 2009, 11:14

Re: MySQL Server will not start

Post by sedmonds » Fri 11. Dec 2009, 11:19

Discovered this possible solution this morning,

For Mac OS X 10.5.8:
1. Launch the Activity Monitor and select "My Processes".
2. Look for the process, "mysqld" and quit each instance. Might see more than one instance.

Possible conflicting and multiple "mysqld" processes causing the sql server instance not to launch.

Not sure if this is the safe way, but it appeared to solve the issue.

Let me know if this works or not for you.

mrweavey
Posts: 1
Joined: Thu 31. Dec 2009, 20:37

Re: MySQL Server will not start

Post by mrweavey » Thu 31. Dec 2009, 20:38

Worked for me!

Thanks!

guyvdb
Posts: 3
Joined: Thu 7. Jan 2010, 10:11
Location: Antwerp, Belgium
Contact:

Re: MySQL Server will not start

Post by guyvdb » Thu 7. Jan 2010, 11:19

Well, I've got a similar problem.
Mysql will not start.
The mysql log shows: msqld_safe A mysqld process already exists

When running the activity monitor, there is no mysqld process running...

sedmonds
Posts: 3
Joined: Fri 11. Dec 2009, 11:14

Re: MySQL Server will not start

Post by sedmonds » Mon 11. Jan 2010, 08:25

guyvdb wrote:Well, I've got a similar problem.
Mysql will not start.
The mysql log shows: msqld_safe A mysqld process already exists

When running the activity monitor, there is no mysqld process running...
This may help if there is a System Pref conflict under Sharing:

1. Locate "Sharing" under the "System Prefs"
2. Goto "Web Sharing" and turn off and turn on (Low-tech suggestion, I know)

Let me know if this works-- something wonky happens sometimes when MAMP meets OS X web server functionality. The two just don't always dance well together at times.

guyvdb
Posts: 3
Joined: Thu 7. Jan 2010, 10:11
Location: Antwerp, Belgium
Contact:

Re: MySQL Server will not start

Post by guyvdb » Mon 11. Jan 2010, 10:52

No such service is active...
Only remote management and screen sharing are on.

sedmonds
Posts: 3
Joined: Fri 11. Dec 2009, 11:14

Re: MySQL Server will not start

Post by sedmonds » Mon 11. Jan 2010, 12:54

guyvdb wrote:No such service is active...
Only remote management and screen sharing are on.
I'm interested in your issue. My hunch is that multiple Mysql server instances are running. If not, let us know.

Beyond these 3:

1. Looking in "System Prefs" and restarting "Sharing > Web Server" or,
2. Checking "System Prefs > Other: MySQL Pref" and and stop a running instance or,
3. Scroll thru all the process dropdowns under the Activity Monitor,

I'd guess a re-install of MAMP and a system reboot is less hassle.

_cole
Posts: 1
Joined: Tue 2. Nov 2010, 05:52

Re: MySQL Server will not start

Post by _cole » Tue 2. Nov 2010, 05:56

severin wrote:Hi wsday,

I guess that you have another installation of mysql and MAMP's mysql is getting confused by the other my.cnf file. Do you still need it? Can you find it and try to rename it to see if the problem persists?

Thanks,

Severin Kurpiers
living-e AG
This fixed my problem! Thanks!

Process:
quit MAMP

run the following commands on terminal:
mv /etc/my.cnf /etc/my.cnf.bak

Start MAMP

tsjones
Posts: 1
Joined: Wed 18. May 2011, 00:13

Re: MySQL Server will not start

Post by tsjones » Wed 18. May 2011, 00:15

Thanks, though I only had one instance running. I quit that, tried again and it worked!

Gazbrad
Posts: 1
Joined: Mon 18. Jul 2011, 08:14

Re: MySQL Server will not start

Post by Gazbrad » Mon 18. Jul 2011, 08:18

There seems to be a million ways of solving this supposedly, but mine was to simply move my.cnf out of the etc to the desktop. Started MAMP, it works!
As someone else said earlier in this thread, there must have been just too many my.cnf files to allow it to start.

Good luck.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 1 guest