Skip to main content

Getting Started

This is the first week we take CS3216, anxious but excited.

The first lecture was encouraging. It's full of interesting shares from Prof. Leong, the seniors and the classmates. I was not confident at the beginning, but these talented people in the room just make me feel good. They are nice and passionate:-)

In the show-and-tell, people shared their fabulous talents in various ways. There are designers, guitar soloist,nerdy engineers,dancers...I was really astonished by many great works they have done. I can even recall most of their great works now, an electromechanics robotics hands with sensor controls, handicraft-buildings made from hundreds of matches, a fancy video with automatic Microsoft voice, an original guitar solo song for his girl, a wheeled robot with complex control algorithms, a serious Q/A website for sex,an ipad app,a web app, a WOW video, poster design leaflets... So many interesting stuffs! I myself played a short guitar song, "Don't Panic" by Coldplay,which expressed my wishes to these new friends.

"Oh, we're sinking like stones,
All that we fought for,
All those places we've gone,
All of us are done for.

We live in a beautiful world,
Yeah we do, yeah we do,
We live in a beautiful world,

Oh, we're sinking like stones,
All that we fought for,
All those places we've gone,
All of us are done for.

We live in a beautiful world,
Yeah we do, yeah we do,
We live in a beautiful world.
Oh, all that I know,
There's nothing here to run from,
And there, everybody here's got somebody to lean on. "

Above are all the non-technical part lah. We've got a lot to do even in the first week. The facebook assignment is due soon and we've formed our groups immediately after the first lecture. In Saturday's workshop, we've learned Unix commands, AWS(Amazon Web Service) configurations, PHP&MySQL. An AWS server instance has already been settled. We are expected to master PHP&MySQL within one week and make our very first facebook application in less than two week's time. Our group members are all new to these stuffs. Fortunately, we are really passionate and having our second group meeting tomorrow.

Below are some useful Unix commands for MySQL root password resetting shared by ELDWIN in the class forum. I attach it here for my own reference as well as for people on the web who may encounter the same problem.


Unable to find the default root password. Follow these steps to reset the root password to 'password' and login to create your user.


cd /home
/etc/init.d/mysqld start --user=mysql
kill `cat /var/run/mysqld/mysqld.pid`
cat > file
UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';<Enter>
FLUSH PRIVILEGES;<Enter>
<Ctrl+D>
mysqld_safe --init-file=/home/file &

rm file


Login
mysql -u root -p
Enter password: password


Create User and login
mysql -u root -p
Enter password: password
mysql>CREATE USER 'david'@'localhost' IDENTIFIED BY 'password';
mysql>quit
mysql -u david -p
Enter password: password
Change root pass to something strong
mysqladmin -u root -p password newestpassword
Enter password: password

Comments

Popular posts from this blog

Time to Write sth about the NOC Israel

After more than a month's waiting, I received an email today from the Financial Aid office saying that I am not permitted to go for the NOC Israel programme.  Dear Shaohuan I refer to your appeal to participate in NUS Overseas College (NOC) Israel.   As spoken on 6 November 2012, we understand that you are very eager to attend the NOC and we had submitted your appeal, together with the appeal from NOC to the sponsor.  However, we regret to inform you that your appeal to participate in NOC Israel is not successful.   The sponsor has advised that you look for an internship locally instead, if needed.   We wish you all the best.  Actually, I was informed by the NOC coordinator that she has been informed by her colleagues that the sponsor officially rejected my appeal(together with Prof.Ben's and NOC's appeals) on 21st Nov. She tried to confirm with her colleagues whether the decision is final or not, hoping to help me for the last try. However, I guess the result won't b

2018 New Year Resolution

This year, let me try to draft the new year resolution based on the Willpower Instinct: Step 1:  List down the best things of the past year. 1. I proposed to my fiancee when she and her mum visited Singapore in July. We were then registered as officially married on her birthday on 28th Nov in Beijing. It was really the most important event of my life so far. After years' of long distance relationship, we finally made it. Though it will still take her another half year before coming to Singapore, we were both thankful that we really made it. 2. I bought my own apartment. It was a tough process to look for properties. I was so happy when I received the keys. Before that, I shared with my bedroom with my room mates for 3+ years. 3. Fooyo's sales was quite satisfying. We has two big customers, one in the Tourism Industry and another in the Logistics Industry. The products we produced were pretty pioneering and beneficial to the industry.  4. Fooyo succ

IPAD/FB Seminar- Thoughts on Pulse News

Monday's presentation was full of interesting sparks. Of all the eleven teams, only one chose to present FB app, which is Sims Social. The others all chose to present ipad apps. That's not so surprising as Ipad(Tablets) is the most recent platform and there are a lot of blank spaces for us to fill in. The ten ipad apps shared in the seminar covers various fields like e-payment, news-media, education. What surprised me most is that many of us find education a very promising area for mobile app development...As ipads are being utilized as an educational tools in various educational levels, education is really going to be a great pie. Wait, I need to finish comments for my assigned app first. Pulse News, a news media app with good social features. News media are getting more social and mobile and probably "cloudy" in the recently years. Organizing news media contents can be a promising area since there are always interesting things happening around and people just have