1.添加可被访问账号,%表示不限制访问账号,并设置密码
2.设置访问账号可操作内容
表示只可查询
3.C#代码实现:
/// <summary>
/// 连接或断开数据库的全局变量
/// </summary>
MySqlConnection connection = null;
MySqlConnectionStringBuilder conn_string = null;
/// <summary>
/// 连接数据库填充參數
/// </summary>
/// <returns></returns>
public void ConnectionDB()
{
conn_string = new MySqlConnectionStringBuilder();
conn_string.Database = "world";
//conn_string.Server = "localhost";//本地访问
conn_string.Server = &#