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;

UI/UX Design by

We make sure that your target audience has the best possible experience with your digital product. You get:

Design tailored to your audience
Proven processes customized to your needs
An expert team of experienced designers

MySQL: How to clone a database

UI/UX Design by