SQL

One of my study notes about SQL. It covers all the concepts about SQL syntax, database design, query, etc.


Uploaded on authorSTREAM by maggie.zhou

IPSec

I present the basic concept of IPSec. Let you know about what are differnets between the Transport mode and Tunnel mode, what are differents between ESP and AH, etc.

Uploaded on authorSTREAM by maggie.zhou

Ad hoc Network protocols

This note presents three important Ad hoc network routing protocol. These three protocol are the typical routing types which inspired other protocols. Once you understood these three, you will easily get the key point from others.


Uploaded on authorSTREAM by maggie.zhou

Lost root password in MySQL

If you lost the root password of MySQL, there are several to get over it. On Windows, you can use the following steps to reset a new password.

1. close currrent running MySQL: you can go to windows task manager(by press Ctrl+ALT+DEL), and end the process: mysqld-nt.exe

2, open a dos command window

3, set path as your mysql installation path, and into bin, mine is:

c:/program files/mysql/bin

4, Input command:

mysqld-nt --skip-grant-tables

if there is nothing shows up, it means everything is ok

5, Then, you need open another dos command window

6, Still, set the same path: c:/program files/mysql/bin

7, input:

mysql

then press ENTER key, to get into mysql

if you see:

mysql>

then so far so good

8. After the previous steps, please input:

use mysql;
update user set password=password("123456") where user="root";
flush privileges;

12345 is you new password for root user, please don't forget the semicolon and use double quote for both password and user name root

9. Quit mysql by input
\q

10, On Final step, you need to log out then login windows.

Now, you can use the new password to login mysql in the normal way.