import clr;
import System;

clr.AddReference("TCAdmin.DatabaseProviders.MySql");
clr.AddReference("TCAdmin.SDK");
from TCAdmin.DatabaseProviders.MySql import MySqlManager;
from System import String;


mysql_server="144.217.203.158";
mysql_root="renildomarcio";
mysql_password="858822";

with MySqlManager() as mysql:
 escapeduser=mysql.PrepareSqlValue(ThisService.Variables["MySQLUser"]);
 escapedpass=mysql.PrepareSqlValue(ThisService.Variables["MySQLPassword"]);
 mysql.Connect(String.Format("Data Source={0};User Id={1};Password={2};Pooling=False;", mysql_server, mysql_root, mysql_password));

 mysql.ExecuteNonQuery(String.Format("CREATE DATABASE {0};", escapeduser));
 mysql.ExecuteNonQuery(String.Format("GRANT ALL PRIVILEGES ON {0}.* TO '{0}'@'%' IDENTIFIED BY '{1}';", escapeduser, escapedpass));
 mysql.Disconnect();
 mysql.Connect(String.Format("Data Source={0};User Id={2};Password={3};Pooling=False;Database={1};", mysql_server, escapeduser, mysql_root, mysql_password));
 mysql.ImportDatabase(" C:\\Users\\Administrator\\Desktop\\sql\\exile.sql");