The macosxhints Forums

The macosxhints Forums (http://hintsforums.macworld.com/index.php)
-   Networking (http://hintsforums.macworld.com/forumdisplay.php?f=14)
-   -   Can't view localhost after attempts to configure php & mysql (http://hintsforums.macworld.com/showthread.php?t=102467)

tw 06-16-2009 03:06 PM

did you start the mysql server? check the preference pane to see if it's turned on. me, I have a launchd item that starts the server automatically at login - looks like this (not sure where I picked this up, and you may have to adjust the path, but it works. put it in /Library/LaunchDaemons):
Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
        <key>GroupName</key>
        <string>_mysql</string>
        <key>Label</key>
        <string>com.mysql.mysqld</string>
        <key>OnDemand</key>
        <false/>
        <key>Program</key>
        <string>/usr/local/mysql/bin/safe_mysqld</string>
        <key>RunAtLoad</key>
        <true/>
        <key>UserName</key>
        <string>_mysql</string>
        <key>WorkingDirectory</key>
        <string>/usr/local/mysql</string>
</dict>
</plist>

The preference pane didn't work right in MySQL 4; I don't know if they fixed that or not.

mkinnamon 06-16-2009 03:50 PM

Sorry to keep posting, but I figure that more information will only help determine the problem. MySQL showed that it was running in the preference pane as soon as I installed it and allowed me to make the changes I mentioned above. I was unable to stop mysql from the pref pane, though. I tried shutting it down with sudo /usr/local/mysql/support-files/mysql.server stop and got ERROR! Manager of pid-file quit without updating file. I restarted the machine and am unable to start mysql with either the pref pane or terminal. Pref pane asks for my pw, but nothing else happens. Terminal gives same pid-file error above.

mkinnamon 06-16-2009 04:33 PM

Your post reminded me that I'd set up a launchd item the last time I tried to set up mysql. It's a little different, but looks to be similar. When I looked for it, I noticed that I've got two mysql folders in usr/local. One is usr/local/mysql and the other is usr/local/mysql-5.1.35-osx10.5-x86, which is the version I installed this morning. Both folders have all the same subfolders. Could this be an issue?

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>KeepAlive</key>
<true/>
<key>Label</key>
<string>com.mysql.mysqld</string>
<key>Program</key>
<string>/usr/local/mysql/bin/mysqld_safe</string>
<key>RunAtLoad</key>
<true/>
</dict>
</plist>

tw 06-16-2009 05:15 PM

I have a folder called "mysql-standard-4.1.22-apple-darwin8.6.0-powerpc" and a symlink called mysql that points to that folder. if you have two versions installed, I'd suggest you delete the folder called mysql and replace it with a symlink to the recently installed version, otherwise your system will be trying to start up the wrong version.

mkinnamon 06-16-2009 05:30 PM

Ok, I see what you're saying. It does look like the same situation. The Mysql folder is just an alias. Does it look like I missed any configuration steps because mySQL will not start up at all.


All times are GMT -5. The time now is 07:09 PM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Site design © IDG Consumer & SMB; individuals retain copyright of their postings
but consent to the possible use of their material in other areas of IDG Consumer & SMB.