MySQL_Installation_Steps_Configuration

# sudo apt install mysql-server
# sudo mysql_secure_installation
enter mysql root 'password'

reset root password in mysql

# sudo mysql -u root 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY  'password';
FLUSH PRIVILEGES;

Comments

Post a Comment

Popular posts from this blog

Steps_to_Install_Magento_2.4.4_on_Ubuntu_20.04

Image
  Steps to Install Magento 2.4.4 on Ubuntu 20.04 Prerequisites Ubuntu 20.04 Root SSH access. Or regular user with sudo privileges 1. Log in via SSH and update the system Log in to Ubuntu 20.04 VPS with SSH as a root user. You can also login as a regular user with sudo privileges. ssh master @IP_Address -p Port_number Add your server’s actual IP address and SSH port number. It should be in place of IP_address and Port_number. Check if you have the proper Ubuntu version installed on your server. Use the following command - $ lsb_release -a The output should look like this - No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 20.04 .3 LTS Release: 20.04 Codename: focal Ensure that the installed packages are updated to the latest version. Run the following command - $ sudo apt update && sudo apt upgrade 2. Install PHP Magento 2.4.4 is fully compatible with PHP 8.1. Run the following command to install the latest stable version of PHP 8.1...
Read more

SVN Incremental Backup

SVN_VAR=/opt/svnbackup_files DATETIME=`date +%Y%m%d` #for rep in ${SVN_REPPATH}/*;  #1 for word in $(cat /root/backup_repo.txt); #2 do   TSTAMP=`date +%s` #  CURR_REV=`${SVN_BINPATH}/svnlook youngest ${rep}` #1    CURR_REV=`${SVN_BINPATH}/svnlook youngest $SVN_REPPATH/${word}` #2 #  REP_BASE=`basename $rep` #1   REP_BASE=`basename $word` #2   if [ -e ${SVN_VAR}/status/dates/${REP_BASE}.dt ] ; then     REP_LAST_BK_TSTAMP=`cat ${SVN_VAR}/status/dates/${REP_BASE}.dt`     REP_LAST_BK_REV=`cat ${SVN_VAR}/status/revisions/${REP_BASE}.rev`   else     REP_LAST_BK_TSTAMP=0     REP_LAST_BK_REV=0   fi   if [ ${CURR_REV} -gt ${REP_LAST_BK_REV} ] ; then     echo "**********************************************************" #   echo "`date --rfc-2822`  - Incremental back up ${rep} : "  #1     echo "`date --rfc-2822`  - Incremental back up ${word} : " #2   ...
Read more

How To Reset Root Password On CentOS 7

Image
  1 – In the Boot Grub Menu Select Option to Edit 2 – Go to the line of Linux 16 and change ro with “rw init=/sysroot/bin/sh” 3 – Now press “Control+x” to start on single-user mode 4 – Now access the system with this command chroot /sysroot 5 – Reset the password passwd root 6 – Exit Chroot exit 7 – Reboot your system reboot That’s it. Enjoy.
Read more