In this tutorial, How do i use MySQL change user password. MySQL and MariaDB are the popular open source Database for Linux Opearating System.   Mysql change root password Note: MySQL default root password is empty when you installed Mysql or MariaDB. Now, How to reset Mysql root or other users password on linux. For MySQL 5.7 or above version Step 1: Open the command terminal. sudo mysql -u root Step 2: select the database. use mysql; Step 3: Change the root password. UPDATE mysql.user SET authentication_string=PASSWORD(' YOUR_NEW_PASSWORD ') WHERE USER='root'; FLUSH PRIVILEGES; exit For MySQL 5.7 version or older version Step 1: Open the command terminal. sudo mysql -u root Step 2: select the database. use mysql; Step 3: To change the MySQL root user password. update user set password=PASSWORD(" YOUR_NEW_PASSWORD ") where User='root'; FLUSH PRIVILEGES; exit  Step 4: restart the MySQL service systemctl restart mysq

In this tutorial, How to create a local yum repository for Centos / Redhat / Fedora . Step 1: mount your ISO file Create folder path /mnt/dvd [huupv@huupv huuphan.com]$ sudo mkdir -p /mnt/dvd If you used a physical DVD [huupv@huupv huuphan.com]$ sudo umount /dev/sr0 [huupv@huupv huuphan.com]$ sudo mount -t iso9660 -o ro /dev/sr0 /mnt/dvd If you used an IOS file [huupv@huupv huuphan.com]$ sudo mount -t iso9660 -o loop,ro /opt/CentOS-7-x86_64-Minimal-1511.iso /mnt/dvd Step 2: Create the repository I'll use vi editor. [huupv@huupv huuphan.com]$  vi /etc/yum.repos.d/local.repo Add the following lines: [local] name=Local DVD or ISO repository baseurl= file:///mnt/dvd gpgcheck=0 enabled=1 Step 3: Test your local repository I installing nginx package using local repository. [huupv@huupv huuphan.com]$  yum install --disablerepo="*" --enablerepo="local" nginx

In this tutorial, Using find command to search for file or directory in linux. How to use linux find command find all folder or file. Using -exec flag. Linux find command How to find all folder not contain path ".backup" as below [huupv@huupv huuphan.com]$ find ./ -type d -not -path "*/.backup*"    -exec ls -ld {} \; The screen output terminal: How to find all symbolic link in current folder. [huupv@huupv huuphan.com]$ find ./ -type l -exec ls -l {} \; The screen output terminal: Conclusion Thought the article, you can use Linux find command. I hope will this your helpful

In this tutorial, How do I  use alias command to stop and start service with human language. Linux alias tips For example, you execute command " vagrant halt app1 " to stop server app1  or " vagrant halt db " to stop server db in Vagrant . you can use alias command the define command  "stop_app1" or "stop_db" Step 1: Add command end of line in .bashrc file  [huupv@huupv ~]$ vim .bashrc The terminal output as below Step 2: Apply the change [huupv@huupv ~]$ source .bashrc The screen output terminal: [huupv@huupv ~]$ cd my_ansible/example01/ [huupv@huupv example01]$ stop_app1 DEPRECATION: The 'sudo' option for the Ansible provisioner is deprecated. Please use the 'become' option instead. The 'sudo' option will be removed in a future release of Vagrant. ==> app1: Attempting graceful shutdown of VM... [huupv@huupv example01]$ stop_db DEPRECATION: The 'sudo' option for the Ansible provi

In this tutorial, How to Install sublime text editor on Fedora with DNF. Sublime Text is a powerful tool for web developer. I love it Install sublime Text editor Use sublime official yum repository for fedora system. Open terminal and import gpg $ sudo rpm -v --import https://download.sublimetext.com/sublimehq-rpm-pub.gpg $ sudo dnf config-manager --add-repo https://download.sublimetext.com/rpm/stable/x86_64/sublime-text.repo Install sublime text latest version your system. $ sudo dnf install sublime-text Access sublime text Yeah coding :)

Netstat command is tool to check the network configure and activity. The default centos 7 and RHEL 7 not found netstat command. How to use netstat command on Centos 7 and RHEL 7 To find out which package provides "netstat" command. yum provides */netstat Or yum whatprovides */netstat The output screen as below net-tools-2.0-0.22.20131004git.el7.x86_64 : Basic networking tools Repo        : @base Matched from: Filename    : /bin/netstat Install netstat command # yum install net-tools The output screen as below: Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile  * base: ftp.jaist.ac.jp  * epel: mirror.ehost.vn  * extras: ftp.jaist.ac.jp  * updates: ftp.jaist.ac.jp Resolving Dependencies --> Running transaction check ---> Package net-tools.x86_64 0:2.0-0.22.20131004git.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================

System Commands Command Description Examples shutdown bring your system down shutdown -h now --> Halt or poweroff after shutdown shutdown -r now --> Reboot after shutdown halt stop your system. halt reboot reboot your system. reboot uptime Tell how long the system has been running. uptime runlevel find the previous and current system runlevel. runlevel printenv print all or part of environment printenv env run a program in a modified environment env hostname show or set the system's your host name hostname --> show the system's host name hostname newhostname -->- set the system's uname print system information uname -a --> print all information locale Displays information about the current locale, or

In this tutorial, How to remind USER notify passowrd expired on zimbra . Bash script have policy 120 days password expired. zimbra notify password expired by bash script To create zimbra_notify_change _pass.sh file to notify password expired for all zimbra accounts. [root@mail ~]# cat zimbra_notify_change_pass.sh The content zimbra notify password expired as below #!/bin/bash # Bash scriptzimbra password expiry email notification. # To be performed as daily cronjob run as zimbra USER. ######################### Set environment ######################### #Todays date, in seconds: DATE=$(date +%s) # Set some vars: # First notification in days, then last warning: FIRST="7" LAST="3" # pass expiry in days POLICY="120" # Sent from: FROM="[email protected]" # Get all _USERs - it should run once only. _USERS=$(/opt/zimbra/bin/zmprov -l gaa | egrep -v "spam|ham|virus-quarantine|galsync"); # zimbra password variable

How to save and recover Data from Crashed Disks with ddrescue command? This is program is useful to rescue data in case I/O error. How to solve problem “wrong fs type, bad option, bad superblock” error? mount: wrong fs type, bad option, bad superblock on 192.168.1.155:/home/shared, missing codepage or helper program, or other error (for several filesystems (e.g. nfs, cifs) you might need a /sbin/mount.<type> helper program)  In some cases useful info is found in syslog - try dmesg | tail or so. My server OS: Centos 7 HDD1: /dev/sda1 HDD2: /dev/sdb1 ( mount point /mnt) HDD2: /dev/sdb1 is crash, not mount pint /mnt. How to do it! I attach a new HDD3 disk: /dev/sdc1 on my system. use ddrescue command. Install ddrescue on centos # yum install ddrescue How do I use ddrescue command rescue a partition in /dev/sdb1 to /dev/sdc1 ## is damaged, you will need to recreate it somehow on /dev/sdb. ## ddrescue -f -n /dev/sdb /dev/sdc logfile ddrescue -d -f -r3 /dev/sdb /dev/s

A reverse DNS lookup or reverse DNS resolution (rDNS) is the querying of the Domain Name System (DNS) to determine the domain name associated with an IP address – the reverse of the usual "forward" DNS lookup of an IP address from a domain name. Zimbra tips, How to Enable PTR/Reverse DNS lookup Incomming Email. More information from Wikipedia . Step 1: Enable zimbraMtaRestriction as command below su - zimbra zmprov mcf +zimbraMtaRestriction "reject_unknown_client_hostname" Step 2: zimbra postfix reload postfix reload Conclusion Thought the article, you can use "Zimbra Enable PTR/Reverse DNS lookup Incomming Email" as above . I hope will this your helpful.