Coding

Useful MySQL Commands

Below is a list of very common MySQL/MariaDB commands that any developer should know by heart. Export MySQL Database mysqldump -u username -p database_name > dump.sql Import MySQL Database mysql -u username -p -h servername database-name < data.sql Login MySQL Database mysql -uusername -p Create MySQL Users CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘password’; GRANT ALL PRIVILEGES ON database . tablename […]

Useful MySQL Commands Read More »

MongoDB Mac Cheat Sheet

Install MongoDB with brew. To start mongodb: brew services start mongodb To stop mongodb if it’s already running: brew services stop mongodb Tools Robomongo / Robo 3T MongoDB Compass Commands MongoDB Statistics – To get stats about MongoDB server, type the command db.stats() Currently selected database, use the command db Databases list, use the command

MongoDB Mac Cheat Sheet Read More »