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
Stopping MySQL database server: mysqld.

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

# mysqld_safe --skip-grant-tables &
[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
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.


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
Stopping MySQL database server: mysqld 
STOPPING server from pid file /var/run/mysqld/
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.

Increase RAM on nutanix ce

source link


I setup nutanix community edition today in my homelab, and I was interested in looking at how to change both CVM vCPU and vRAM count.  By default my CVM was running 4vcpu and 12GB of RAM, and I wanted to change this to 8vcpu and 15GB RAM (my CE whitebox is running a 8 core Atom CPU and 16GB RAM)
KVM is very new to me, so for my own documentation sake here are the steps I used.
SSH onto the KVM hypervisor using your favorite SSH client, in my case KVM was running on IP address, whilst the CVM was using
Logon using default nutanix KVM credentials of
Username: root
Password: nutanix/4u
First run virsh list to get the name of your Nutanix CVM, in my case it is NTNX-72c234e3-A-CVM
virsh list
Next, run virsh dominfo NTNX-72c243e3-A-CVM to confirm number of CPU’s and RAM
To change the amount of RAM, in my case I increased from 12GB to 15GB, run the following commands and substitute the approriate CVM name
#Shutdown CVM
virsh shutdown NTNX-72c243e3-A-CVM
#Set vRAM (There should be two  – -dashes before config)
virsh setmaxmem NTNX-72c243e3-A-CVM 15G – -config
virsh setmem NTNX-72c243e3-A-CVM 15G – -config
#start VM again
virsh start NTNX-72c243e3-A-CVM
To change the amount of CPU’s, edit the virsh XML file.
#edit virsh xml
virsh edit NTNX-72c243e3-A-CVM
cpu change
This will open the VM XML file using vi editor, use the following commands to edit the file (I always forget how to edit in vi, so I will show the steps here for my own sake)
  1. Press “i” to enter insert mode
  2. Use the arrow keys to move to the following line 4
  3. Change the 4 to whatever you want, in my case I did 8
  4. Press “esc” to exit insert mode
  5. Type “:wq” to write out and save the file
#Shutdown the Nutanix CVM
virsh shutdown NTNX-72c243e3-A-CVM
#Start the Nutanix CVM again
virsh start NTNX-72c243e3-A-CVM
Run virsh dominfo again to confirm the changes were successful
virsh dominfo NTNX-72c243e3-A-CVM
virsh dom info
In most cases with Nutanix CE, the defaults are 99% OK for most people.  So test to see if it’s really required to increase or decrease CVM resources according to required workload and hardware specifications.  In my case I saw no difference so I set the defaults back


Nutanix Nested Setup Guide

recommended link