FATAL ERROR: Could not find mysqld & Missing Port 3306

[David Gentry]

Ryan,

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."

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

Note: The directories searched for mysqld by the database install script don't exist anymore on my Mac.


How can I resolve the "FATAL ERROR"?

David

On Dec 21, 2010, at 11:06 AM, Ryan Schmidt wrote:

On Dec 21, 2010, at 10:08, David Gentry wrote:

> FATAL ERROR: Could not find mysqld
> 
> I removed a version of mysql from my iMac, and I installed the latest community version.  As a recommended post-installation task, I ran mysql_install_db.
> 
> Here is the command and the response:
> 
> command: "/opt/local/lib/mysql5/bin/mysql_install_db ;"
> 
> response: "exit;
> 
> 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.
> 
> logout"
> 
> Would someone please give me more detail on the specific "make install" command that I should use?  
> 
> 
> Missing port 3306
> 
> After installing the latest MacPorts' mysql and mysql.server, I used my iMac's Network Utility to do a port scan on 127.0.0.1, and 3306 was not listed as an open port.  I received the same result to a port scan on localhost.
> 
> If I fix the "fatal error" above, will 3306 become an open port or is there something else that I need to do?

You should uninstall the MySQL that you installed via the disk image you downloaded from the MySQL web site, and instead use the MySQL provided by MacPorts. Instructions for setting it up are in our wiki:

http://trac.macports.org/wiki/howto/MAMP#mysql



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/20110106/c0670f24/attachment.html>