Solved

MySQL wont start on snow leopard

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
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…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

749 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