we have a WooCommerce website and it has a single database. In wp-config.php I setup the connection to the database:
user1 name_of_db psw_for_db_user
We have an ERP software installed on our office and we bought a software that will synchronize some data between ERP and WooCommerce (orders, prices, stock…).
This software (in the middle between the ERP and WC) needs to connect directly to the database of WordPress. Can I create a new user and password to connect to the database from this software? Is it safe or we will ecounter problems in WordPress/WooCommerce having two different db users making changes in the db?