Solved

MySQL wont start on snow leopard

Posted on 2011-03-08
3
1,452 Views
Last Modified: 2013-11-11
Hi All

I have another issue on my Xserve running snow leopard 10.6.5.
I cannot seem to get mysql to start, the system log repeatedly gives me the following
"Mar  8 23:06:59 "server" com.apple.launchd[1] (org.mysql.mysqld[14545]): Exited with exit code: 1
Mar  8 23:06:59 "server" com.apple.launchd[1] (org.mysql.mysqld): Throttling respawn: Will start in 10 seconds
Mar  8 23:07:09 "server" com.apple.launchd[1] (org.mysql.mysqld[14547]): Exited with exit code: 1
Mar  8 23:07:09 c"server" com.apple.launchd[1] (org.mysql.mysqld): Throttling respawn: Will start in 10 seconds"

MySQL Log gives the following
"2011-03-08 22:16:29 Australia/Sydney   Starting MySQL Service
2011-03-08 22:16:29 Australia/Sydney   Starting MySQL daemon...
2011-03-08 22:16:29 Australia/Sydney   MySQL: verifying/installing default my.cnf
2011-03-08 22:16:29 Australia/Sydney   MySQL startup options: socket=/var/mysql/mysql.sock; datadir=/var/mysql; pid-file=/var/mysql/cDNS.NAME.pid; network=YES
2011-03-08 22:16:59 Australia/Sydney [E]  {
    NSLocalizedDescription = "MySQL daemon start up timed-out.";

Starting it via server admin just sits on "Starting", trying to start it via terminal gives me
mysql = _empty_dictionary

Tried to install the latest version of mySQL however still getting the same issues.
Any help would be appreciated
0
Comment
Question by:ProphecY01
3 Comments
 
LVL 13

Accepted Solution

by:
agarwalrahul earned 250 total points
ID: 35093992
You can try the Folllowing steps:

Open Terminal & Type:
sudo chown -R root:wheel /Library/StartupItems/MySQLCOM

Restart the computer

Open Terminal & Type:

cd /usr/local/mysql to navigate to the mysql interface.

Type: sudo echo

You will be asked for your computer admin password

Then type:

sudo bin/mysqld_safe &

Then type:

bin/mysqladmin -u root password 'xxxxxxxx' to enter a root password for the MySQL database (replace xxxxxx with your chosen password. This should probably be different from your computer password. Don't forget the single quotes). Logout of Terminal

Then look at System Preferences. Under "Other", click the MySQL button. It should say "The MySQL Server Instance is running". If you want MySQL to start on StartUp, check the box "Automatically Start MySQL Server on Startup"

For reference:
http://discussions.info.apple.com/message.jspa?messageID=12820394#12820394
0
 
LVL 27

Expert Comment

by:Tolomir
ID: 35422529
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Install MySQL 5.6 and PHP on Centos Linux 6 96
Anti-virus for Linux Server 15 121
adobe premier render 10 37
Restore 1Password 6 from different Mac Mini Time Machine 2 13
Windows 10 is here and for most admins this means frustration and challenges getting that first working Windows 10 image. As in my previous sysprep articles, I've put together a simple help guide to get you through this process. The aim is to achiev…
#Citrix #POC #XenDesktop #vCenter #VMware #ESX
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
A short film showing how OnPage and Connectwise integration works.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now