Making sure /usr/local/bin is in my $PATH on mac
echo $PATH will print your path. If you see /usr/local/bin between some colons, then it’s in your path.
macos
Mac install and open mysql using terminal
(Updated for 2017) When you installed MySQL it generated a password for the root user. You can connect using and type in the generated password. Previously, the root user in MySQL used to not have a password and could only connect from localhost. So you would connect using
Reset MySQL root password using ALTER USER statement after install on Mac
If this is NOT your first time setting up the password, try this method: And if you get the following error, there is a high chance that you have never set your password before: To set up your password for the first time: Reference: https://dev.mysql.com/doc/refman/5.6/en/alter-user.html
sed command with -i option failing on Mac, but works on Linux
If you use the -i option you need to provide an extension for your backups. If you have: The command (note the lack of space between -i and ” and the -e to make it work on new versions of Mac and on GNU): Create 2 backup files like: There is no portable way to avoid making backup files because it is impossible … Read more
Python can’t find module NLTK
On OS X you could have multiple installation of Python, so investigate it first: All within /usr/bin are built-in and all other in /usr/local/bin are external installed by Homebrew or some other package manager. If you’re using pip or pip3 from /usr/local, then you’ve to use the same Python instance, otherwise they’re different instances. Just install it via pip: or for Python 3: then run … Read more
Python: source code string cannot contain null bytes
For posterity: I had the same problem and fixed it using, The file seemed to be messed up in numerous ways (wrong endings, etc); no idea how… See https://stackoverflow.com/a/2399817/230468
psql: FATAL: role “postgres” does not exist
NOTE: If you installed postgres using homebrew, see the comment from @user3402754 below. Note that the error message does NOT talk about a missing database, it talks about a missing role. Later in the login process it might also stumble over the missing database. But the first step is to check the missing role: What is the … Read more
Can’t connect to MySQL server on ‘127.0.0.1’ (61) on Mac
Having some trouble creating a mysql connection. The mysql instance is running in system preferences and I have made sure the mysql config file is in the right location(Test settings passed). When I go into Test DB connections I get red cross on all three sections.(open database connections, get server version, get server OS). Running … Read more
psql: command not found Mac
You have got the PATH slightly wrong. You need the PATH to “the containing directory”, not the actual executable itself. Your PATH should be set like this: without the extra sql part in it. Also, you must remove the spaces around the equals sign. Keywords: Postgresql, PATH, macOS, OSX, psql