On your local OSX environment using Terminal or iTerm you can create a MySQL database, database user, and password, as well as, assign all privileges to the user for the database. Knowing your credentials, before beginning you will need to know the following: user: {user} password: {password} database: {database} For my local environment, I'll be using these credentials user root password root database safs   Walkthrough the steps to build your database: The initial step is to...

When attempting to backup mysql using the mysqldump command mysqldump -u root -p database_name > backup.sqlHowever, it is throwing an error: mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespacesWhat to do?   Reading through the mysqldump documentation, you need use --no-tablespaces.  So the command becomes mysqldump -u root -p database_name > backup.sql...