How can I reset my MySQL password?
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 :
- Start the mysqld demon process using the –skip-grant-tables option with this command
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
- from the mysql prompt execute this command to be able to change any password
- Then reset/update your password
- If you have a mysql root account that can connect from everywhere, you should also do:
- Alternate Method:
- And if you have a root account that can access from everywhere:
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
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
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.
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
should give you as below
List of devices attached
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.
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
the above command doesn’t do anything
my /etc/network/interfaces file looks like this
iface lo inet loopback
iface eth0 inet dhcp
iface eth1 inet dhcp
So to start the network all i have to do is
The above command will start eth1 interface
Type in this code in the dialpad
Then it will ask for the code that you purchased from somebody else.
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
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\connect_to_jc.sh"
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
To download a file
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%.
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
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
- Open the picture that you want to use as your passport picture in gimp.
- Make sure that it is resized to 2″ x 2″ using the image resize option. Save that as your original.
- 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.