FATAL ERROR: Could not find mysqld & Missing Port 3306

[David Gentry]

Your guess makes sense to me: the FATAL ERROR came from script that I did not successfully uninstall.  I ran "which mysql_install_db5" and the response was "/opt/local/bin/mysql_install_db5."  The file and a lot of other mysql files were in that directory and they were alias files.  I sent all of them to trash.

Then I returned to the web page you referred me to: http://trac.macports.org/wiki/howto/MAMP#mysql.

I ran the following commands as instructed to "set up the main database."  I separated the commands by semicolons.

sudo -u mysql mysql_install_db5 
sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ 
sudo chown -R mysql:mysql /opt/local/var/run/mysql5/ 
sudo chown -R mysql:mysql /opt/local/var/log/mysql5/

The response was: "sudo: mysql_install_db5: command not found."

Then I ran the same four commands separated by "&".  I got the same result.

Then I ran the first command alone.  I got the same result.

Then I ran the following three commands as advised, "If that doesn't work try this":
sudo mysql_install_db5 
sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ 
sudo chown -R mysql:mysql /opt/local/var/run/mysql5/
The result was the same: "sudo: mysql_install_db5: command not found."
Then I searched for "mysql_install_db5."  I found two Portfiles at the following locations:
/opt/local/var/macports/sources/rsync.macports.org/release/ports/databases/mysql5-server-devel/Portfile
/opt/local/var/macports/sources/rsync.macports.org/release/ports/databases/mysql5-server/Portfile
Then I ran "which mysql_install_db5" and the result was to return me to the command prompt.
Background: A couple of days ago, when I tried to uninstall all disk image copies of MySQL, I also uninstalled MacPorts' "mysql5" and "mysql5-server."  Then I installed the ports.  I got no error messages.  Then I ran "port selfupdate" and I did not get any error messages.
What does this information tell you?

On Jan 7, 2011, at 12:18 AM, Ryan Schmidt wrote:

On Jan 6, 2011, at 13:49, David Gentry wrote:

> Following your advice, I carefully tried to uninstall all previous disk image versions of MySQL that I had downloaded from the MySQL web site.  Also, I uninstalled mysql and mysql-server using sudo port uninstall.
> 
> I carefully followed the instructions on the web page you referred me to.  I had no trouble until I tried to install the mysql main database.  Using both commands given, I received the following reply:
> 
> "FATAL ERROR: Could not find mysqld
> 
> The following directories were searched:
> 
>    /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/libexec
>    /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/sbin
>    /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/bin
> 
> If you compiled from source, you need to run 'make install' to
> copy the software into the correct location ready for operation.
> 
> If you are using a binary release, you must either be at the top
> level of the extracted archive, or pass the --basedir option
> pointing to that location."

Whatever program or script generated that error message was not provided by MacPorts; MacPorts would not be looking for anything in /usr/local/mysql-5.5.6-rc-osx10.6-x86_64. I'm guessing it was provided by the software in that directory, which I'm guessing was not completely uninstalled.

What command did you run to get that message? something with mysql_install_db(5)? (It appears to be an error message that mysql_install_db(5) would produce.) If so, where is the mysql_install_db(5) it is finding -- what does "which mysql_install_db" (or "which mysql_install_db5") say? What is in your path -- what does "echo $PATH" say?


> I searched for "mysqld" on my Mac, and I found it installed yesterday (when I was working from your referred instructions) in the following two locations:
> 
> /opt/local/libexec/mysqld
> 
> /opt/local/var/macports/software/mysql5/mysql5.1.51_0/opt/local/libexec/mysqld

Yes, those are where MacPorts would install it, so that's normal.



David J. Gentry
President
Good Things -- Small Packages, LLC
205-637-8000
dgentry at localbusinesswebsites.com
www.localbusinesswebsites.com






-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20110107/eaaf6e6c/attachment.html>