ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'QQ4VfpbrAOXE86gwMjGZmn';
ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'QQ4VfpbrAOXE86gwMjGZmn';
FLUSH PRIVILEGES;


CREATE DATABASE sehatdb;
CREATE DATABASE sehatdb_b2b;
CREATE DATABASE fdpp;
CREATE DATABASE erp_live;
CREATE DATABASE dashboard;
CREATE DATABASE sehat_manufacturer_db;
CREATE DATABASE common_payment_stores;

..\mysql.exe -u root -p QQ4VfpbrAOXE86gwMjGZmn -P 3310 sehatdb < sehatdb.sql
..\mysql.exe -u root -p QQ4VfpbrAOXE86gwMjGZmn -P 3310 sehatdb_b2b < sehatdb_b2b.sql
..\mysql.exe -u root -p QQ4VfpbrAOXE86gwMjGZmn -P 3310 fdpp < fdpp.sql
..\mysql.exe -u root -p QQ4VfpbrAOXE86gwMjGZmn -P 3310 erp_live < erp_live.sql





CREATE DATABASE  common_payment_stores.sql
CREATE DATABASE  conn_master_all_db.sql
CREATE DATABASE  dashboard.sql
CREATE DATABASE  erp_live.sql
CREATE DATABASE  erp_live_log.sql
CREATE DATABASE  excluded_order.sql
CREATE DATABASE  fdpp.sql
CREATE DATABASE  pending_vaccinations.sql
CREATE DATABASE  produpd.sql
CREATE DATABASE  prod_prices_dashborad.sql
CREATE DATABASE  scheduled_orders.sql
CREATE DATABASE  sehatdb.sql
CREATE DATABASE  sehatdb_b2b.sql
CREATE DATABASE  sehat_manufacturer_db.sql

Get-Content .\common_payment_stores.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 common_payment_stores
Get-Content .\conn_master_all_db.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 conn_master_all_db
Get-Content .\dashboard.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 dashboard
Get-Content .\erp_live.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 erp_live
Get-Content .\erp_live_log.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 erp_live_log
Get-Content .\excluded_order.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 excluded_order
Get-Content .\fdpp.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 fdpp
Get-Content .\pending_vaccinations.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 pending_vaccinations
Get-Content .\produpd.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 produpd
Get-Content .\prod_prices_dashborad.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 prod_prices_dashborad
Get-Content .\scheduled_orders.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 scheduled_orders
Get-Content .\sehatdb.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 sehatdb
Get-Content .\sehatdb_b2b.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 sehatdb_b2b
Get-Content .\sehat_manufacturer_db.sql | ..\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 sehat_manufacturer_db

D:\live_xampp\mysql\bin\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 -e "CREATE DATABASE IF NOT EXISTS sehat_manufacturer_db CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;"
D:\live_xampp\mysql\bin\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 --default-character-set=utf8mb4 erp_live_log < D:\live_xampp\mysql\bin\dbs\erp_live_log.sql
D:\live_xampp\mysql\bin\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 --default-character-set=utf8mb4 sehatdb < D:\live_xampp\mysql\bin\dbs\sehatdb.sql
D:\live_xampp\mysql\bin\mysql.exe -u root -pQQ4VfpbrAOXE86gwMjGZmn -P 3310 --default-character-set=utf8mb4 sehat_manufacturer_db < D:\live_xampp\mysql\bin\dbs\sehat_manufacturer_db.sql

D:\live_xampp\htdocs\sehat\config\config.php
User = '4p07h3c4r3'
pass = 'Umg$}Jb1Ctt07=@'


D:\live_xampp\htdocs\sehat_b2b\config\config.php
User = 'misc._sit3s_uzer'
pass = 'd+{J-}d{J7jyC_r'


D:\live_xampp\htdocs\fdpp\config\config.php
User = '4p07h3c4r3'
pass = 'Umg$}Jb1Ctt07=@'