Here is how you can easily backup & restore MySQL database. Backup MySQL database: mysqldump –u root –p password db_1 > db_1.sql Restore MySQL database: mysqldump –u root –p passwor... Read More...
Use this command to create a new username, with a password, but no grant permissions. CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; Use this command to remove a username. DROP USER 'username'@'localhost'; ... Read More...