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...