Sunday, 14 August 2011

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

No comments:

Post a Comment