Solved

MySQL wont start on snow leopard

Posted on 2011-03-08
3
1,464 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
An introduction to the wonderful sport of Scam Baiting.  Learn how to help fight scammers by beating them at their own game. This great pass time helps the world, while providing an endless source of entertainment. Enjoy!
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…

728 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