I always find myself needing to look up this exact syntax. mysql> create database MY_DATABASE character set utf8; Query OK, 1 row affected (0.04 sec) mysql> grant all privileges on MY_DATABASE.* to ‘MY_USERNAME’@’localhost’ identified by ‘MY_PASSWORD’; Query OK, 0 rows affected (0.06 sec)
I’ve used this setup so many times now that I wanted to write up a list post explaining how I do it. This method is something I found on this site, but I just wanted to add my own commentary. The idea is that you are developing a website locally using git, and you want … Continue reading Lightweight Deployment With Git
If you read tech news or startup news, you are probably numb to it. “Here is a new startup that will revolutionize our daily lives.” “This site promises to forever change the way we communicate.” “This one is a new twist on local deals.” “You can watch videos or listen to music—but with your friends.” … Continue reading Jitterbunk. Bunk Your Friends.
Then head over to raunk.com. This is the startup I’ve been working on this summer with four friends. It’s a site where you can rate anything, and from the ratings, see best-of lists from different perspectives. Since the best-of lists are generated dynamically and from tags, we can generate really amazing and specific lists. Let … Continue reading If you thought that was interesting…
UPDATE March 28, 2013: Many people have commented here and emailed me that it no longer works for you. I have made an update to fix the bookmarklet for those with Facebook Graph Search. You can get the new bookmarklet here Updated Facebook Friends Ranking Bookmarklet to Work with Graph Search ========================================== UPDATE February 14, … Continue reading Who Does Facebook Think You Are Searching For?
. Check out the cs181 final project that we just made. It’s a text based adventure game, with a little console in the browser where you can explore some history and cases relating to press freedom for bloggers. Play the Game Here project by me, Eric Conner, and Zach Galant. Browse the code on github
I will try and go through how I set up Ruby on Rails on a new ec2 instance. I will include in my explanation the errors I faced along the way and how I solved them in the hope that showing the wrong way and then the right way is more helpful than just the … Continue reading rails from scratch on ubuntu 11.04
Based on an article from: http://blog.taggesell.de/index.php?/archives/73-Managing-Amazon-EC2-SSH-login-and-protecting-your-instances.html After you have created your instance: Save the Public DNS, it looks something like ec2-########-compute.amazonaws.com After you have your keypair, run this command $ ssh -i mykeypair.pem ubuntu@ec2-##########.compute-1.amazonaws.com You should be in now. Cool. Now set yourself up your own user account. adduser jkeesh Adduser is the one you … Continue reading Setting up User Accounts, Password Authentication, and SSH Keys on a New EC2 Instance
So I saw a post on my wall from a friend, but something just didn’t sound right. Again, it was a case of the Facebook spam that somehow tricked you into posting something you didn’t want to post to all of your friends. And many people made the mistake, and it spread fast. Mainly, it … Continue reading Wow, Facebook Hackers
I was trying to get mod_rewrite working on my WordPress blog which is on a server I set up. Except it just didn’t work. Solution (which you can find on the internet, but not that easily if you don’t know what to look for) is that in your httpd.conf file, you need to make sure … Continue reading mod_rewrite reminder