How to Change the MySQL root Password in Linux or OSX via Command Line

If you have forgot the MySQL root password, can’t remember or want to break in….. you can reset the mysql database password from the command line in either Linux or OS X as long as you know the root user password of the box you are on:

Stop MySQL

1 2 3

sudo /usr/local/mysql/support-files/mysql.server stop

Start it in safe mode:

1 2 3

sudo mysqld_safe --skip-grant-tables

This will be an ongoing command until the process is finished so open another shell/terminal window, log in without a password:

1 2 3

mysql -u root

1 2 3

UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';

Change the lowercase password to what you want – with single quotes.

1 2 3

FLUSH PRIVILEGES;

1 2 3

\q

Start MySQL

1 2 3

sudo /usr/local/mysql/support-files/mysql.server start source:http://coolestguidesontheplanet.com/how-to-change-the-mysql-root-password/

Nghề chia sẻ

1. Thông điệp chính
2. Tóm tắt nội dung
3. Đánh giá
4. Ứng dụng

Software engineering skills

An old friend, also a Computer Science professor asked me about the impact of the global financial crisis to the software industry. He is worrying that his students may not be able to get jobs when they graduated. I told him that I think the current crisis will have significant impact to the software industry but to the better because it will eliminate inefficient companies and create many opportunities for well managed companies. Regarding employment, software engineering jobs is still rated on the top five in global demand so he should not have to worry. Assume that his students have the skills that match the demands of the industry.

Knowing yourself

Knowing yourself means not only that you find out what you are good at and what you like, it also means discovering what you are not good at and what you don't like. Both help you to see your goal in life.

Top 100 Tools for Learning 2012

A learning tool is a tool to create or deliver learning content/solutions for others, or a tool for your own personal or professional learning. (http://c4lpt.co.uk)
Here is the Top 100 Tools for Learning 2012 as voted for by 582 learning professionals worldwide. Below is the slideset available via Slideshare and beneath it the textual list.  Other pages are available as follows:

Startup part 1

There is a notion that “startup” is just a small business and “Entrepreneur” is just a “fancy” name for a small business owner. Small businesses such as grocery stores, restaurants, coffee shops, street food business etc all have owners who start their own business. They work hard and hire people, mostly family members. Some are barely profitable as these small businesses are NOT designed to grow. Their goal is simply to survive and support the family. These people have skills and little capital borrowing from relatives. They are not rich and only survive in the local market. Every country has millions of them. Of course, they can be called “entrepreneur” as they seize opportunities and willing to take risks but their goal is only to feed their family, or create jobs for relatives.

Entrepreneur part 2

There is a new government report on business trends. It found that the current economic recession has been a stimulus for entrepreneurship. By examining the percentage of people who start their own companies, it found that in 2008, there was 3% went up to 6.5% in 2009, then 12% in 2010, and 18.5% in 2011. The interesting fact is a similar situation also happened in 1978. During this economic recession (1978-1982) Steve Jobs started Apple and Bill Gates started Microsoft which stimulated the explosion of the electronic, computer and software industry. The report concluded that economic difficulty tends to stimulate the entrepreneurial spirit.