By:
On:
In: Database, Linux
With: 0 Comments

This is a bit gnarly. If you have a better method of updating the password without triggering a warning about PASSWORD being deprecated, I’m all ears. # Stop MySQL sudo service mysql stop # Make MySQL service directory. sudo mkdir /var/run/mysqld # Give MySQL user permission to write to the service directory. sudo chown mysql: /var/run/mysqld # Start MySQL manually, without permission checks or networking. sudo mysqld_safe –skip-grant-tables –skip-networking & # Log in without a password. mysql -uroot mysql Update the password for the root user. UPDATE mysql.user SET authentication_string=PASSWORD(‘YOURNEWPASSWORD’), plugin=’mysql_native_password’ WHERE User=’root’ AND Host=’%’; EXIT; # Turn off MySQL. sudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdownRead More →

By:
On:
In: Linux
With: 0 Comments

On Redhat, run this command lsblk You will see this NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sr0 11:0 1 1024M 0 rom sda 8:0 0 100G 0 disk ├─sda1 8:1 0 1G 0 part /boot └─sda2 8:2 0 99G 0 part ├─rootvg-swaplv (dm-0) 253:0 0 8G 0 lvm [SWAP] ├─rootvg-rootlv (dm-1) 253:1 0 14G 0 lvm / ├─rootvg-homelv (dm-2) 253:2 0 6G 0 lvm /home ├─rootvg-varlv (dm-3) 253:3 0 8G 0 lvm /var └─rootvg-tmplv (dm-4) 253:4 0 8G 0 lvm /tmp sdb 8:16 0 250G 0 diskRead More →

By:
On:
In: Linux, Programming
With: 0 Comments

Environment variable GIT_SSH_COMMAND: From Git version 2.3.0, you can use the environment variable GIT_SSH_COMMAND like this: GIT_SSH_COMMAND=”ssh -i ~/.ssh/id_rsa_example” git clone example Note that -i can sometimes be overridden by your config file, in which case, you should give SSH an empty config file, like this: GIT_SSH_COMMAND=”ssh -i ~/.ssh/id_rsa_example -F /dev/null” git clone example Configuration core.sshCommand: From Git version 2.10.0, you can configure this per repo or globally, so you don’t have to set the environment variable any more! git config core.sshCommand “ssh -i ~/.ssh/id_rsa_example -F /dev/null” git pull git pushRead More →

By:
On:
In: General
With: 0 Comments

Do you see this error in your mail.log? “Please contact your Internet service provider since part of their network is on our block list (AS3140)” Go to this website to request Outlook team to remove your IP from their blocked list. https://support.microsoft.com/en-us/getsupport?oaspworkflow=start_1.0.0.0&wfname=capsub&productkey=edfsmsbl3&locale=en-us&ccsid=635611717755428181Read More →

By:
On:
In: Linux
With: 0 Comments

This happens when we upgrade my Apache to 2.4.7 , it turns out that we haven’t got removed the old authentication configuration completely, we just remove the require valid user   #AuthType Basic AuthName “My Login” AuthUserFile /var/www/.htpasswd #Require valid-user   The fix is: we have to remove all authentication configuration lines #AuthType Basic #AuthName “My Login” #AuthUserFile /var/www/.htpasswd #Require valid-user    Read More →