Here is a way to create a duplicate of one database, with all its tables and their data, under a new name.

Make a dump of your source database:
```
mysqldump -uroot -p my_project -r my_project.sql
```
Or, if you only want to dump the database's table structure (schema) without any contents:
```
mysqldump -uroot -p my_project -r my_project.sql --no-data
```
Open up a MySQL shell:
```
mysql -uroot -p
```
From the MySQL shell, create a new database and populate it with the dumped data:
```
CREATE DATABASE my_project_copy;
USE my_project_copy;
SOURCE my_project.sql;
```

Create a user and give it permissions to the new database:

CREATE USER new_user IDENTIFIED BY 'some_password';
GRANT ALL ON my_project_copy.* TO 'new_user'@'localhost' IDENTIFIED BY 'some_password';
FLUSH PRIVILEGES;

Do you need DevOps-experts?

Your development team has a full backlog? No time for infrastructure architecture? Our DevOps team is ready to support you!

We build reliable cloud solutions with Infrastructure as code
We are experts in security, Linux and databases
We support your dev team to perform

MySQL: How to clone a database

Do you need DevOps-experts?