Categories
Uncategorized

What is this blog about?

You may have stumbled upon this site and are wondering, what is it about? You’re seeing random posts about business, bicycles and code – what’s the tie in? I will explain, but first a story.

My friend and I met for coffee this week at Streaming Cafe. He asks me this question, “What’s your perfect day look like?” He said his was to wake up 7:30 am, be flexible enough to meet for coffee and pursue his dreams, while still getting everything done he needs to for his job. It’s an interesting question when he explained why he asked it. He said if you know what your perfect day looks like then you can plan to your life to get to it. Not every job is going to enable him to live that kind of day, so he needs to plan to get the right kind of job. You know what I mean.

Well this blog is part of my perfect day. It is the place that I write about anything that I am learning and find interesting and that I think will be valuable to me in the future when I look back at it, and hopefully valuable to others reading it. I’ve intentionally left the discussion broad. Interests change and topics on this blog might change too.

It’s probably going to be more relevant to you if you are starting a business, or thinking of starting a business. Because I am a young founder of a young business, I write about many of the problems that we have faced. I also write about other topics as well, but business definitely get’s written about more than the others. I try to write posts for myself that I would read, so that one day I can look back on these pages and remember what I was learning.┬áHope you find this interesting and thanks for visiting.

Categories
MySQL Uncategorized

How to reset the root mysql password if you forget it

I’ve been setting up a LEMP server, Nginx Mysql PHP, on Ubuntu and lost my root mysql password. Here’s what I did to reset the password in Terminal.

After logging into my server via SSH on Terminal I ran the following lines in Terminal.

# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &
$ mysql -u root

mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit

# /etc/init.d/mysql stop
# /etc/init.d/mysql start
$ mysql -u root -p

I found this solution in an answer by Benjamin Manns to a StackOverflow question here.