Fatal Error Could Not Find ./bin/my_print_defaults Mysqld
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us my_print_defaults command not found Learn more about Stack Overflow the company Business Learn more about hiring developers or
Fatal Error Could Not Find Mysqld
posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow
My_print_defaults Not Found
Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Mysql_install_db cannot find file up vote 6 down vote
Sudo Mysql_install_db Command Not Found
favorite 3 I am trying to use mysql_install_db I am getting 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 be at the top level of the extracted archive, or pass the --basedir option pointing mysql_install_db is deprecated to that location. I've tried using which my_print_defaults It returns: /usr/local/bin/my_print_defaults So I try the command: mysql_install_db --base-dir=/usr/local/bin/ I still receive the same error, though. Please help. mysql database install share|improve this question edited Sep 9 '15 at 4:02 asked Jul 11 '13 at 19:02 in code veritas 2,21731839 well did you compile mysql from source? –Dany Khalife Jul 11 '13 at 19:10 Sounds like a broken MySQL install. Which platform are you trying to install on? –tadman Jul 11 '13 at 19:13 @DanyKhalife Mountain Lion. I'm just not sure what to do. There are so many different suggestions out there. Seems like I'm just digging a hole. –in code veritas Jul 11 '13 at 19:19 Going to uninstall a bunch of gems/brews and try to install everything. –in code veritas Jul 11 '13 at 19:47 IMHO it's much easier to install the MySQL version packaged for OS X. –Cfreak Jul 12 '13 at 19:21 add a comment| 5 Answers 5 active oldest votes up vote 18 down vote accepted Annoyingly, this just means you have to be in the right directory to execute this. Make sure you're in /usr/local/Cellar/mysql/
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about arch linux mysql Stack Overflow the company Business Learn more about hiring developers or posting ads with error the server quit without updating pid file mac us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is error 2002 (hy000): can't connect to local mysql server through socket '/tmp/mysql.sock' (2) a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up mysql_install_db gives FATAL ERROR: Could not find my-default.cnf up vote 7 down vote favorite http://stackoverflow.com/questions/17601341/mysql-install-db-cannot-find-file 1 I've download MySQL and I'm trying to setup the MySQL grant tables, but when I type: scripts/mysql_install_db --basedir=/usr/local I get the error above. I'm not sure how to fix it, as my-default.cnf is in the support_files directory and I believe I'm setting the basedir correctly. (This is on mac btw) mysql database installation share|improve this question edited Apr 23 '13 at 18:53 Chris Laplante 21.4k1067112 asked Mar 16 '13 http://stackoverflow.com/questions/15451640/mysql-install-db-gives-fatal-error-could-not-find-my-default-cnf at 16:25 Josh Antonson 36113 check that file it is existed or not –PSR Mar 16 '13 at 16:29 add a comment| 2 Answers 2 active oldest votes up vote 6 down vote (I'm assuming you're using Homebrew, since I hit the same issue trying to do the same thing on Homebrew on my macbook) I believe you need to point it to the actual mysql directory in the cellar as its basedir, not at /usr/local (since that's just things symlinked from the cellar dir). So, in my case, I had to use: $ mysql_install_db --basedir=/usr/local/Cellar/mysql/5.6.10 share|improve this answer answered Apr 2 '13 at 17:59 rascalking 2,31311011 i am running into these errors with brew too, and other errors. brew....what a disaster. –OneSolitaryNoob Sep 13 '15 at 22:03 add a comment| up vote 0 down vote To extend to rascalking's answer, the current mysql installs to /usr/local/mysql/ via brew. But to get over timestamp issue and the permission issue the full command will be: sudo mysql_install_db --basedir=/usr/local/mysql --explicit_defaults_for_timestamp Don't forget to set your password first incase you skipped the instruction: /usr/local/mysql/bin/mysqladmin -u root password 'new-password' share|improve this answer edited Feb 1 at 12:42 Zulu 2,75771932 answered Dec 20 '14 at 19:10 user2391411 1 add
include MySQL, PHP and Apache which I have documented in the Web Server Basics article. While installing Percona, I ran across the following error: # /usr/local/mysql-5.5/bin/mysql_install_db FATAL https://www.mikemackintosh.com/mysql-fatal-error-my-print-defaults ERROR: Could not find ./bin/my_print_defaults If you compiled from source, you need to https://bugs.mysql.com/bug.php?id=44405 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. If you use my article, the MySQL page documents not found 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] Flashcache setup error is : ioctl failed OK Filling help tables... 120302 10:03:09 fatal error could [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 productivity. Hope this relieves someones headache. Tagged under could-not-find, fatal-error, my-print-defaults, mysql-2, mysql5-5, my_print_defaults, percona, and others This post was written by Mike Mackintosh, a decorated
Email Updates: Status: Not a Bug Impact on me: None Category:MySQL Server: Installing Severity:S2 (Serious) Version:MySQL-5.1.34-linux-i686-glibc23 OS:Linux (Fedora 8) Assigned to: View Add Comment Files Developer Edit Submission View Progress Log Contributions [22 Apr 2009 10:30] Christine Tang Description: Hi! I downloaded MySQL-5.1.34-linux-i686-glibc23 and I had been trying to install mysql but to no avail. I followed the steps documented in INSTALL-BINARY file up to shell> scripts/mysql_install_db --user=mysql Unfortunately, the error returned was scripts/mysql_install_db: line 99: ./bin/my_print_defaults: cannot execute binary file Neither host 'localhost.localdomain' nor 'localhost' could be looked up with ./bin/resolveip Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option I've tried with --force but it's still not working. I'm installing into my Fedora 8 virtual pc.... Any ideas/solutions to this problem? How to repeat: 1. Download mysql-5.1.34-linux-i686-glibc23. 2. Extract the package and make a copy to /usr/local. 3. ln -s /usr/local/mysql-5.1.34-linux-i686-glibc23 mysql. 4. cd mysql 5. chown -R mysql . 6. chgrp -R mysql . 7. scripts/mysql_install_db --user=mysql. [29 Apr 2009 9:30] Sveta Smirnova Thank you for the report. Please provide output of hostname command [30 Apr 2009 3:06] Christine Tang Hostname returns "localhost.localdomain". [30 Apr 2009 7:21] Sveta Smirnova Thank you for the feedback. Please provided content of /etc/hosts and output of `my_print_defaults` and `resolveip localhost.localdomain` also. [30 Apr 2009 7:59] Christine Tang /etc/hosts contain: 127.0.0.1 localhost.localdomain localhost localhost ::1 localhost6.localdomain6 localhost6 I can't execute "resolveip localhost.localdomain" Nevertheless, I