MYSQL

Grant permission to user from remote or local location

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'Password';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'69.xx.xx.20' IDENTIFIED BY 'camp1';

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Password');

UPDATE mysql.user SET Password=PASSWORD('Qua4rigadb') WHERE User='root';

SET PASSWORD FOR 'sugarcrm'@'localhost' = OLD_PASSWORD('Qua4rigadb');

HOW TO RESET THE ROOT PASSWORD

1 Stop Mysql
2 Start mysql with --skip
(#mysqld --skip-grant-tables --user=root&; mysql -uroot)

3 UPDATE mysql.user SET Password=PASSWORD('Qua4rigadb') WHERE User='root';
4 FLUSH PRIVILEGES;

To backup all the mysql
# Dump all mysql databases
mysqldump --add-drop-table -A --user=root --password=Qua4rigadb > /backup/mysql/databases.sql



GRANT ALL PRIVILEGES ON *.* TO 'shanker'@'localhost' IDENTIFIED BY 'shanker123' WITH GRANT OPTION;