Reset mysql root password if forgotten

How can I reset my MySQL password?

IconsPage/warning.png Following this procedure, you will disable access control on the MySQL server. All connexions will have a root access. It is a good thing to unplug your server from the network or at least disable remote access.

To reset your mysqld password just follow these instructions :

  • Stop the mysql demon process using this command :
    •    sudo /etc/init.d/mysql stop

  • Start the mysqld demon process using the –skip-grant-tables option with this command
    •    sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &

Because you are not checking user privs at this point, it’s safest to disable networking. In Dapper, /usr/bin/mysqld… did not work. However, mysqld --skip-grant-tables did.

  • start the mysql client process using this command
    •    mysql -u root

  • from the mysql prompt execute this command to be able to change any password

  • Then reset/update your password
    •    SET PASSWORD FOR root@'localhost' = PASSWORD('password');

  • If you have a mysql root account that can connect from everywhere, you should also do:
    •    UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';

  • Alternate Method:
    •    USE mysql
         UPDATE user SET Password = PASSWORD('newpwd')
         WHERE Host = 'localhost' AND User = 'root';

  • And if you have a root account that can access from everywhere:
    •    USE mysql
         UPDATE user SET Password = PASSWORD('newpwd')
         WHERE Host = '%' AND User = 'root';

For either method, once have received a message indicating a successful query (one or more rows affected), flush privileges:


Then stop the mysqld process and relaunch it with the classical way:

sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
Posted in mysql

Remove a google account from Samsung

I added a google account to my Galaxy Note 4. There was this main gmail account and then a secondary account that i use for my kids for them to watch youtube. I added this to my phone and the nightmare started. Once my trial is finished i wanted to remove it from my phone. The proper way is to go to Settings->General->Accounts and then select Google and it should show the list of Google accounts that are linked to the phone and i can select the one that i want to remove.

Once i click Google, the Settings will crash. After some research I found that all you have to do is open Gallery and then from the Menu you can go to the accounts associated and from there you can remove that account

Posted in Uncategorized

lg e 970 apn

From Setting Select the network tab


Select the Tethering & Network

Now select the mobile networks

Now Select Access Point names

Once you get that blank screen, click the menu button on the right, right next to the home button, and select “New APN”

Select each item and enter the data as given by your service provider

Once it is all done, now hit the menu button again and hit save.

Posted in Uncategorized

Nexus 9 Fastboot

I had a need to reinstall the image in my Nexus 9 tablet. the recommended way was to go through the fastboot. Download the images from the google website. Then get the tablet to the fastboot and then install the software.

Make sure that you have adb and other tools installed in your computer. With the debugging enabled the

$adb devices

should give you as below

List of devices attached
HT4AJJT03366 device

should list your devices, if it is says unauthorized then you need to accept the dialog box “Allow debugging” in the tablet, that you authorize the computer to access the tablet.

Now issue the command

adb reboot recovery

This will take you the HBOOT or fastboot screen.

Posted in Uncategorized

Debian Start network

Start network after reboot

Based on my configuration, after booting the linux machine it doesn’t automatically start the network manager and establish internet connection.

I used to do

/etc/init.d/network restart

the above command doesn’t do anything

my /etc/network/interfaces file looks like this

auto lo
iface lo inet loopback
iface eth0 inet dhcp
iface eth1 inet dhcp

So to start the network all i have to do is

ifup eth1

The above command will start eth1 interface

Posted in Uncategorized

Note 4 unlock screen

Type in this code in the dialpad


Then it will ask for the code that you purchased from somebody else.

Posted in Uncategorized

Automate Git Bash

Connect to Linux machine

How to connect to a linux machine from a git bash terminal on Windows 7 machine.
Git bash is already a batch command executed from the dos command prompt.
So if you want to execute a linux shell script such as


, then you need to create a batch file that will start a git bash terminal and then execute this shell script.

First create a shell script that looks like as follows

export DISPLAY=localhost:0.0
ssh -X -p <port_number>  -i <location_of_the_private_key>  <user@server>

The above shell script will set the display to forward X11 and use the private key to connect to the linux machine.

Now create the batch file

C:\Windows\System32\cmd.exe /c ""C:\Program Files (x86)\Git\bin\sh.exe" --login -i -- C:\Projects\"
Posted in Uncategorized



Git Bash has scp but not sftp.

$scp -i <identity_file_name> -P <port_number> ./201* user_name@hot_name:<destination_directory>

Now i can upload all the files that start with 201, and as long as i’m in the same folder where the files


It is very easy to perform upload and download files once we get into the sftp shell.
It can be done by issuing the following command. If you don’t have the public/private key implemented then you
have to enter the password to login.

$sftp -i<identify_file_name> -P<port_number> user_name@host_name

Once you are in the shell, it will look like this


To upload a file

sftp>put <file_name>

To download a file

sftp>get <file_name>
Posted in SFTP

LG E970 Tricks

Go to Factory Reset

You can go to LG Factory reset, only if the bootloader is not unlocked. Then turn the phone completely off.
Hold the volume down button and then press the power button.

Go to download mode

Once rooted and the bootloader unlocked it will be difficult to go to download mode. So power off the system. then hold both power up + down button. Then connect power through the usb port. Now you are in the download mode. The system won’t go to download mode, if the battery is below 50%.

Hidden Menu



when in stock rom

Unlock LG E970

How to unlock your LG E970

Model: LG E970

1 – Insert a non-accepted or an accepted sim card
2 – Go to dial screen and press 2945#*970#
3 – Select Network Lock (Once selection of Network lock and it say Not Yet Personalized then please select the service provider and input the SPCK code)

NCK = Network Lock
NSCK = Network Subset Lock
SPCK = Service Provider Lock

99.9% of the time you just need NCK or SPCK

If Phone says, “Code Accepted” or “Network Unlock Successful” or “Not Yet Personalized” your phone is fully unlocked

Posted in Uncategorized

Gimp – Passport Photo


You already have a picture that is 2″ x 2″ and meets all the regulations of the passport office.

Here is the original picture


The goal is to create a tile of pictures i.e., 4″x6″ standard photo that will give you 6 of the pictures that you need like below




  1. Open the picture that you want to use as your passport picture in gimp.
  2. Make sure that it is resized to 2″ x 2″ using the image resize option. Save that as your original.
  3. Filters->Map->Tile option from the menu and it will look like this


Select the correct size of the new image which is 4″x6″ and the aspect ratio should be unlinked. Also select “Create a new Image”. It should look as below


Now press OK, you got your passport picture in tile.

Posted in Uncategorized