/// <summary>
/// 创建一个数据库用户
/// </summary>
/// <param name="user"></param>
/// <param name="Password"></param>
/// <param name="grantOwnerDatabase"></param>
/// <param name="description"></param>
/// <returns></returns>
public override bool CreateUser(string user, string Password, string grantOwnerDatabase, ref string description)
{
description = "";
if (!VaildStringParameters(ref description, user, Password, grantOwnerDatabase))
{
return(false);
}
grantOwnerDatabase = grantOwnerDatabase.Trim();
if (!grantOwnerDatabase.StartsWith("`", StringComparison.Ordinal) || !grantOwnerDatabase.EndsWith("`", StringComparison.Ordinal))
{
grantOwnerDatabase = "`" + grantOwnerDatabase + "`";
}
if (!Open(ref description))
{
return(false);
}
string comm = string.Format("CREATE USER '{0}'@'%' IDENTIFIED BY '{1}';\r\n GRANT ALL ON {2}.* TO '{3}'@'%';\r\n flush privileges;",
user, Password, grantOwnerDatabase, user);
DatabaseFactory.MySQL mysql = new DatabaseFactory.MySQL(this.ConnectionString);
int result = mysql.ExecuteNonQuery(comm);
Close();
if (result < 0)
{
description = "数据库指令执行发生错误，返回值是 " + result.ToString() + "||" + comm;
return(false);
}
return(true);
}
/// <summary>
/// 创建一个新的数据库
/// </summary>
/// <param name="database"></param>
/// <param name="description"></param>
/// <returns></returns>
public override bool CreateDatabase(string database, ref string description)
{
description = "";
if (!VaildStringParameters(ref description, database))
{
return(false);
}
database = database.Trim();
if (!database.StartsWith("`", StringComparison.Ordinal) || !database.EndsWith("`", StringComparison.Ordinal))
{
database = "`" + database + "`";
}
DatabaseFactory.MySQL mysql = new DatabaseFactory.MySQL(this.ConnectionString);
try
{
int result = mysql.ExecuteNonQuery("create database " + database + " DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;");
Close();
if (result < 0)
{
description = "数据库指令执行发生错误，返回值是 " + result.ToString() + "|" + "create database " + database;
return(false);
}
}
catch (Exception e)
{
description = "创建数据库出错！" + e.ToString() + "|" + "create database " + database;
return(false);
}
return(true);
}
