How to MySQL Databases Backup, Restore, and create MySQL user with grant privileges?
In this video shows create How to MySQL Databases Backup, Restore and create mysql user with grant privileges?
How to Backup MySQL Databases?
How to Restore MySQL Database?
How to create mysql user and grant privileges ?
How to Backup MySQL Databases?
mysqldump -u root –p mysql = mysql_backup.sql
==========================
How to Restore MySQL Database?
# mysql -u root –p wordpress = mysql_backup.sql]
============================
How to Backup All MySQL Databases?
mysqldump -u root -p --all-databases = all-databases.sql
How to Restore All MySQL Database?
mysql -u root -p --all-databases = all-databases.sql
=============================
=============================
How to create mysql user and grant privileges
#CREATE USER 'technical'@'localhost' IDENTIFIED BY 'skillslinux@1';
#GRANT ALL ON technicaldatabase.* TO 'technical'@'localhost';
#create database technicaldatabase;
#flush privileges;
If my video is helpful to you then please like and subscribe
Thank you for watching