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

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

cPanel/WHM configuration Backup

 cPanel/WHM Backup Step 1. Check for available/Installed Modules   # /usr/local/cpanel/bin/cpconftool --list-modules cpanel::easy::apache cpanel::smtp::exim cpanel::system::autossloptions cpanel::system::backups cpanel::system::greylist cpanel::system::hulk cpanel::system::modsecurity cpanel::system::mysql cpanel::system::whmconf cpanel::ui::themes Step 2. export all configuration by cpconftool utility, and paste all module showed in Step 1. #/usr/local/cpanel/bin/cpconftool --backup --modules=cpanel::easy::apache,cpanel::smtp::exim,cpanel::system::autossloptions,cpanel::system::backups,cpanel::system::greylist,cpanel::system::hulk,cpanel::system::modsecurity,cpanel::system::mysql,cpanel::system::whmconf,cpanel::ui::themes Step 3 : you will get tar.gz file exported in /home folder.
Read more