Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

If you have that same problem in MySql 5.7.+ :  Access denied for user 'root'@'localhost' it's because MySql 5.7 by default allow to connect with socket, which means you just connect with sudo mysql. If you run sql : SELECT user,authentication_string,plugin,host FROM mysql.user; then you will see it : +------------------+-------------------------------------------+-----------------------+-----------+ |...

Continue reading Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

MySQL backup script

#! /bin/bash### MySQL Server Login Info ###MUSER="root"MPASS="roott123"MHOST="localhost"MPORT="3306"DBNAME="radius"MYSQL="$(which mysql)"MYSQLDUMP="$(which mysqldump)"### File Info #### Save backup in temp directory before upload to serverTEMPDIR="/root/backup_radius" #Exp: ./bkp_temp# Name of bkp file (before the date)FILENAME="Radius_Backup_" #Exp: my_prj_daily_bkp_NOW=$(date +%F)#Create and...

Continue reading MySQL backup script