http://www.emailcashpro.com

Recover MySQL root Password

Recover MySQL database server password with following five easy steps.

Step # 2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password.Step # 1: Stop the MySQL server process.
Step # 3: Connect to mysql server as the root user.
Step # 4: Setup new mysql root account password i.e. reset mysql password.
Step # 5: Exit and restart the MySQL server.
Here are commands you need to type for each step (login as the root user):

Step # 1 : Stop mysql service

# /etc/init.d/mysql stop
Output:
Stopping MySQL database server: mysqld.

Step # 2: Start to MySQL server w/o password:

# mysqld_safe --skip-grant-tables &
Output:
[1] 5988
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6025]: started

Step # 3: Connect to mysql server using mysql client:

# mysql -u root
Output:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Step # 4: Setup new MySQL root user password

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

Step # 5: Stop MySQL Server:

# /etc/init.d/mysql stop
Output:
Stopping MySQL database server: mysqld 
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[6186]: ended

[1]+  Done                    mysqld_safe --skip-grant-tables

Step # 6: Start MySQL server and test it

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

Howto install OS on new SSD for Samsung NP530U

BIOS Options:
  • Fast BIOS Disabled
  • Secure BOOT Disabled
  • CMS BIOS Seleceted
You need Hirens Boot CD (It must have Norton Ghost and Mini WinXP. Check versions 11.X or 15.1 Rebuild edition) on a USB Disk.
  1. Start Windows 7 install from USB Windows 7 Disk.
  2. Remove all partitions from iSSD and Sata HDD.
  3. Install Windows 7 to 24GB iSSD.
  4. On first restart Windows 7 setup (system is stuck normaly on this section), remove Windows 7 USB and use Hirens Boot USB. Start Mini Windows XP.
  5. If you can successfully boot Mini Windows XP, Start Norton Ghost 32 from Hirens Tool
  6. On Norton Ghost, select Copy Disk to Disk and copy iSSD to Sata HDD. After copying, don't restart the system. Only quit Norton from the menu.
  7. Use Partition Wizard from Hirens Tools. Check your new copy SATA HDD status. You must have 100MB System Partiton Active and Primary position, and a second partition for Windows Setup with Primary status.
  8. If all is OK, restart your PC and remove Hirens Boot disk, Windows 7 setup should resume.