You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This repository will help you generate a random mock database based on sensitive database
1. make sure the database configuration is correct in the config.yml file
2. make sure both databases can be accessed remotely (assume user is root and password is root)
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf # comment line: bind-address = 0.0.0.0 in cnf file
sudo service mysql restart
# username is 'root 'and password is 'root'
mysql -u root -proot -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' with grant option;"
mysql -u root -proot -e "FLUSH PRIVILEGES;"
3. currently the code is only tested in the mysql database
4. it will wipe all of the tables of the same db name in the database you want to migrant to.
About
Create Synthetic DataBase based on Sensitive DataBase (for security reason) using Python Sqlalchemy tool