Solved

MySQL wont start on snow leopard

Posted on 2011-03-08
3
1,457 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

In this article we will discuss all things related to StageFright bug, the most vulnerable bug of android devices.
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

808 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