Mysql Fatal Error Could Not Find My_print_defaults
Contents |
Sign in Pricing Blog Support Search GitHub This repository Watch 1,052 Star 29,516 Fork 14,059 Homebrew/legacy-homebrew Code Issues 1 Pull requests 0 Projects 0 Pulse Graphs mysql_install_db => "FATAL ERROR: Could not find ./bin/my_print_defaults" #5407 Closed
My_print_defaults Command Not Found
gagarine opened this Issue Apr 28, 2011 · 9 comments Projects None yet fatal error could not find mysqld Labels None yet Milestone No milestone Assignees No one assigned 9 participants gagarine commented Apr 28, 2011 On a fresh my_print_defaults not found install of mysql $brew install mysql
$ mysql_install_db
FATAL ERROR: Could not find ./bin/my_print_defaults
If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready
Sudo Mysql_install_db Command Not Found
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.
They are a bug on mysql http://bugs.mysql.com/bug.php?id=57062 but I'm not sure is the same. gagarine commented Apr 28, 2011 Ok I found it. You need to run those command. It was specified during the install but I don't watch my screenn when
Mysql_install_db Is Deprecated
somthing compiliing assuming than homebrew was doing all the work form me. $unset TMPDIR $mysql_install_db --verbose --user=whoami --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp I don't close the issue because I think "unset TMPDIR" can be done in the formula. no? adamv commented May 5, 2011 unset needs to be run in the current shell; doing it in the formula won't help. adamv closed this May 5, 2011 xavi- commented May 11, 2011 Thank you very much. This is exactly what I needed. I also missed those commands. Is there's some way to highlight it during the installation process? Maybe change the text to red? henrysingleton commented May 23, 2011 Thanks for this - I totally missed it as well and spent a good 30 mins trying to figure it out :) MySQL is fully working now, though I think I need to figure out how to make it run automatically on startup. et commented Jul 24, 2011 @henrysingleton launchctl load -w /usr/local/Cellar/mysql/5.5.12/com.mysql.mysqld.plist bernardeli commented Aug 21, 2011 missed that too. thanks for this solution. saurabh89 commented Feb 12, 2013 still I am getting the same error.I did these two steps unset TMPDIR $mysql_install_db --verbose --user=whoami --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp getting this error FATAL ERROR: Could not find my_print_defaults The following directories were searched: /usr/local/Cellar
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss arch linux mysql the workings and policies of this site About Us Learn more about
Error The Server Quit Without Updating Pid File Mac
Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow brew install mysql Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each https://github.com/Homebrew/legacy-homebrew/issues/5407 other. Join them; it only takes a minute: Sign up Error running mysql_install_db: could not find ./bin/my_print_defaults up vote 1 down vote favorite I seem to be having an issue getting MySQL 5.6.1.5 to install from Source. I am running RHEL 6. I was able to perform the cmake, make, and make install without issues. I am attempting http://stackoverflow.com/questions/21146305/error-running-mysql-install-db-could-not-find-bin-my-print-defaults to run the mysql_install_db binary and when I do I get the following error: Fatal ERROR: Could not find ./bin/my_print_defaults 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 bat at the top level of the extracted archive, or pass the --basedir option pointing to that location. So I did a check for my_print_defaults using which my_print_defaults, unfortunately it was not found on my machine. I did a locate my_print_defaults as well just for the heck of it and said it was located in /usr/bin/my_print_defaults, however, when I checked /usr/bin for the binary, it was not actually there. I would try to use mysql_install_db --basedir=/usr/bin but I know this won't work as the which and locate commands confirm my_print_defaults isn't on my machine. I looked at mysql_install_db giving error, but that error was not similar to this one. mysql mysql-error-1064 share|improve this question edited Aug 31 '15 at 2:00 P
include MySQL, PHP and Apache which I have documented in the Web Server Basics article. While installing Percona, I ran across the following https://www.mikemackintosh.com/mysql-fatal-error-my-print-defaults error: # /usr/local/mysql-5.5/bin/mysql_install_db FATAL ERROR: Could not find ./bin/my_print_defaults If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for https://lists.macosforge.org/pipermail/macports-users/2011-March/023722.html 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. If not found you use my article, the MySQL page documents how to circumvent the issue. To get the location of your my_print_defaults binary, use the which command: which my_print_defaults /usr/local/mysql-5.5/bin/my_print_defaults Then you can re-run the mysql_install_db script passing the --basedir option, leaving off the /bin/my_print_defaults: # ./scripts/mysql_install_db --basedir=/usr/local/mysql-5.5 --user=mysql Installing MySQL system tables... 120302 10:03:08 [Note] Flashcache bypass: disabled 120302 10:03:08 [Note] fatal error could Flashcache setup error is : ioctl failed OK Filling help tables... 120302 10:03:09 [Note] Flashcache bypass: disabled 120302 10:03:09 [Note] Flashcache setup error is : ioctl failed OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/local/mysql-5.5/bin/mysqladmin -u root password 'new-password' /usr/local/mysql-5.5/bin/mysqladmin -u root -h ubuntu password 'new-password' Alternatively you can run: /usr/local/mysql-5.5/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd /usr/local/mysql-5.5 ; /usr/local/mysql-5.5/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd /usr/local/mysql-5.5/mysql-test ; perl mysql-test-run.pl Please report any problems with the /usr/local/mysql-5.5/scripts/mysqlbug script! Percona recommends that all production deployments be protected with a support contract (http://www.percona.com/mysql-suppport/) to ensure the highest uptime, be eligible for hot fixes, and boost your team's productivi
[ date ] [ thread ] [ subject ] [ author ] Ryan, 1. I tried specifying a basedir as you suggested to no avail. Adding /bin to /opt/local/lib/mysql5 helped but not much. Then I tried sudo mysql_install_db5 --srcdir=/opt/local/lib/mysql5/bin, and I received an error message telling me exactly where mysql_install_db5 was looking for my_print_defaults which was /opt/local/lib/mysql5/bin/extra. I added /extra as a folder to /opt/local/lib/mysql5/bin, and I moved my_print_defaults to that folder. Then I got another error message saying another file was in the wrong place, so I moved it. I moved about 5-8 files from various places, but all of them to /opt/local/lib/mysql5/bin. Sometimes I had to create a folder in /bin to move a file to. 2. Then I ran the same command as in all of the instances above: sudo mysql_install_db5 --srcdir=/opt/local/lib/mysql5/bin, and I received the following: Installing MySQL system tables... 110307 14:31:22 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead. 110307 14:31:22 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. 110307 14:31:22 [Warning] /opt/local/lib/mysql5/bin/sql/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110307 14:31:22 [Warning] /opt/local/lib/mysql5/bin/sql/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110307 14:31:22 [Warning] /opt/local/lib/mysql5/bin/sql/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110307 14:31:22 [ERROR] /opt/local/lib/mysql5/bin/sql/mysqld: unknown option '--enable-named-pipe' 110307 14:31:22 [ERROR] Aborting 110307 14:31:22 [Note] /opt/local/lib/mysql5/bin/sql/mysqld: Shutdown complete Installation of system tables failed! Examine the logs